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

Line 11: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

7: IS_DEBUG_PROCEDURE_ON BOOLEAN;
8: -- End of wraper code generated automatically by Debug code generator
9: PROCEDURE create_tmpt_set(
10: p_api_version IN NUMBER
11: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,x_msg_count OUT NOCOPY NUMBER
14: ,x_msg_data OUT NOCOPY VARCHAR2
15: ,p_aesv_rec IN aesv_rec_type

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

21: ) IS
22: i NUMBER;
23: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
24: l_aesv_rec aesv_rec_type := p_aesv_rec;
25: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
26: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
27: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
28: BEGIN
29: SAVEPOINT create_tmpt_set2;

Line 76: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

72: EXCEPTION
73: WHEN FND_API.G_EXC_ERROR THEN
74: ROLLBACK TO create_tmpt_set2;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
77: ,p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO create_tmpt_set2;

Line 82: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

78: ,p_data => x_msg_data);
79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO create_tmpt_set2;
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
83: ,p_count => x_msg_count
84: ,p_data => x_msg_data);
85: WHEN OTHERS THEN
86: ROLLBACK TO create_tmpt_set2;

Line 89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

85: WHEN OTHERS THEN
86: ROLLBACK TO create_tmpt_set2;
87: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
88: -- store SQL error message on message stack for caller
89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
90: ,p_count => x_msg_count
91: ,p_data => x_msg_data);
92: -- notify caller of an UNEXPECTED error
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

94: END create_tmpt_set;
95:
96: PROCEDURE create_tmpt_set(
97: p_api_version IN NUMBER
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,x_return_status OUT NOCOPY VARCHAR2
100: ,x_msg_count OUT NOCOPY NUMBER
101: ,x_msg_data OUT NOCOPY VARCHAR2
102: ,p_aesv_rec IN aesv_rec_type

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

102: ,p_aesv_rec IN aesv_rec_type
103: ,x_aesv_rec OUT NOCOPY aesv_rec_type
104: ,p_aes_source_id IN OKL_AE_TMPT_SETS.id%TYPE DEFAULT NULL)
105: IS
106: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
107: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
108: l_aesv_rec aesv_rec_type := p_aesv_rec;
109: BEGIN
110: SAVEPOINT create_tmpt_set2;

Line 153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO create_tmpt_set2;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO create_tmpt_set2;

Line 159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

155: ,p_data => x_msg_data);
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO create_tmpt_set2;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162: WHEN OTHERS THEN
163: ROLLBACK TO create_tmpt_set2;

Line 166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

162: WHEN OTHERS THEN
163: ROLLBACK TO create_tmpt_set2;
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
165: -- store SQL error message on message stack for caller
166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
169: -- notify caller of an UNEXPECTED error
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 175: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

171: END create_tmpt_set;
172:
173: PROCEDURE create_tmpt_set(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
176: ,x_return_status OUT NOCOPY VARCHAR2
177: ,x_msg_count OUT NOCOPY NUMBER
178: ,x_msg_data OUT NOCOPY VARCHAR2
179: ,p_aesv_tbl IN aesv_tbl_type

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

177: ,x_msg_count OUT NOCOPY NUMBER
178: ,x_msg_data OUT NOCOPY VARCHAR2
179: ,p_aesv_tbl IN aesv_tbl_type
180: ,x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
182: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
183: i NUMBER;
184: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
185: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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

181: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
182: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
183: i NUMBER;
184: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
185: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
186: BEGIN
187: --Initialize the return status
188: SAVEPOINT create_tmpt_set2;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 205: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

201: ,p_aesv_rec => l_aesv_tbl(i)
202: ,x_aesv_rec => x_aesv_tbl(i)
203: ,p_aes_source_id => NULL
204: );
205: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
206: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
207: l_overall_status := x_return_status;
208: END IF;
209: END IF;

Line 206: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

202: ,x_aesv_rec => x_aesv_tbl(i)
203: ,p_aes_source_id => NULL
204: );
205: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
206: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
207: l_overall_status := x_return_status;
208: END IF;
209: END IF;
210: EXIT WHEN (i = l_aesv_tbl.LAST);

Line 227: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO create_tmpt_set2;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
228: ,p_count => x_msg_count
229: ,p_data => x_msg_data);
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO create_tmpt_set2;

Line 233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

229: ,p_data => x_msg_data);
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO create_tmpt_set2;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236: WHEN OTHERS THEN
237: ROLLBACK TO create_tmpt_set2;

Line 240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

236: WHEN OTHERS THEN
237: ROLLBACK TO create_tmpt_set2;
238: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_set');
239: -- store SQL error message on message stack for caller
240: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
241: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
243: -- notify caller of an UNEXPECTED error
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

246:
247: -- Object type procedure for update
248: PROCEDURE update_tmpt_set(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_aesv_rec IN aesv_rec_type,

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

256: p_atlv_tbl IN atlv_tbl_type,
257: x_aesv_rec OUT NOCOPY aesv_rec_type,
258: x_avlv_tbl OUT NOCOPY avlv_tbl_type,
259: x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
261: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
262: l_aesv_rec aesv_rec_type := p_aesv_rec;
263: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
264: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;

Line 314: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: ROLLBACK TO update_tmpt_set2;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
315: ,p_count => x_msg_count
316: ,p_data => x_msg_data);
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: ROLLBACK TO update_tmpt_set2;

Line 320: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

316: ,p_data => x_msg_data);
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: ROLLBACK TO update_tmpt_set2;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
321: ,p_count => x_msg_count
322: ,p_data => x_msg_data);
323: WHEN OTHERS THEN
324: ROLLBACK TO update_tmpt_set2;

Line 327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

323: WHEN OTHERS THEN
324: ROLLBACK TO update_tmpt_set2;
325: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
326: -- store SQL error message on message stack for caller
327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
328: ,p_count => x_msg_count
329: ,p_data => x_msg_data);
330: -- notify caller of an UNEXPECTED error
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

332: END update_tmpt_set;
333:
334: PROCEDURE update_tmpt_set(
335: p_api_version IN NUMBER
336: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
337: ,x_return_status OUT NOCOPY VARCHAR2
338: ,x_msg_count OUT NOCOPY NUMBER
339: ,x_msg_data OUT NOCOPY VARCHAR2
340: ,p_aesv_rec IN aesv_rec_type

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

338: ,x_msg_count OUT NOCOPY NUMBER
339: ,x_msg_data OUT NOCOPY VARCHAR2
340: ,p_aesv_rec IN aesv_rec_type
341: ,x_aesv_rec OUT NOCOPY aesv_rec_type) IS
342: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
343: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
344: l_aesv_rec aesv_rec_type := p_aesv_rec;
345: BEGIN
346: SAVEPOINT update_tmpt_set2;

Line 388: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO update_tmpt_set2;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
389: ,p_count => x_msg_count
390: ,p_data => x_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO update_tmpt_set2;

Line 394: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

390: ,p_data => x_msg_data);
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO update_tmpt_set2;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
395: ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397: WHEN OTHERS THEN
398: ROLLBACK TO update_tmpt_set2;

Line 401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

397: WHEN OTHERS THEN
398: ROLLBACK TO update_tmpt_set2;
399: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
400: -- store SQL error message on message stack for caller
401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
402: ,p_count => x_msg_count
403: ,p_data => x_msg_data);
404: -- notify caller of an UNEXPECTED error
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 411: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

407:
408:
409: PROCEDURE update_tmpt_set(
410: p_api_version IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412: ,x_return_status OUT NOCOPY VARCHAR2
413: ,x_msg_count OUT NOCOPY NUMBER
414: ,x_msg_data OUT NOCOPY VARCHAR2
415: ,p_aesv_tbl IN aesv_tbl_type

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

413: ,x_msg_count OUT NOCOPY NUMBER
414: ,x_msg_data OUT NOCOPY VARCHAR2
415: ,p_aesv_tbl IN aesv_tbl_type
416: ,x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
418: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
419: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
420: i NUMBER;
421: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;

Line 418: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

414: ,x_msg_data OUT NOCOPY VARCHAR2
415: ,p_aesv_tbl IN aesv_tbl_type
416: ,x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
417: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
418: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
419: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
420: i NUMBER;
421: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
422: BEGIN

Line 440: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

436: ,x_msg_data => x_msg_data
437: ,p_aesv_rec => l_aesv_tbl(i)
438: ,x_aesv_rec => x_aesv_tbl(i)
439: );
440: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
441: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
442: l_overall_status := x_return_status;
443: END IF;
444: END IF;

Line 441: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

437: ,p_aesv_rec => l_aesv_tbl(i)
438: ,x_aesv_rec => x_aesv_tbl(i)
439: );
440: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
441: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
442: l_overall_status := x_return_status;
443: END IF;
444: END IF;
445: EXIT WHEN (i = l_aesv_tbl.LAST);

Line 462: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: ROLLBACK TO update_tmpt_set2;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
463: ,p_count => x_msg_count
464: ,p_data => x_msg_data);
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_tmpt_set2;

Line 468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

464: ,p_data => x_msg_data);
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_tmpt_set2;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471: WHEN OTHERS THEN
472: ROLLBACK TO update_tmpt_set2;

Line 475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

471: WHEN OTHERS THEN
472: ROLLBACK TO update_tmpt_set2;
473: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_set');
474: -- store SQL error message on message stack for caller
475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
476: ,p_count => x_msg_count
477: ,p_data => x_msg_data);
478: -- notify caller of an UNEXPECTED error
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 485: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

481:
482: --Put custom code for cascade delete by developer
483: PROCEDURE delete_tmpt_set(
484: p_api_version IN NUMBER
485: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
486: ,x_return_status OUT NOCOPY VARCHAR2
487: ,x_msg_count OUT NOCOPY NUMBER
488: ,x_msg_data OUT NOCOPY VARCHAR2
489: ,p_aesv_rec IN aesv_rec_type) IS

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

487: ,x_msg_count OUT NOCOPY NUMBER
488: ,x_msg_data OUT NOCOPY VARCHAR2
489: ,p_aesv_rec IN aesv_rec_type) IS
490: i NUMBER :=0;
491: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
492: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_set';
493: l_aesv_rec aesv_rec_type := p_aesv_rec;
494: BEGIN
495: SAVEPOINT delete_tmpt_set2;

Line 535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO delete_tmpt_set2;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO delete_tmpt_set2;

Line 541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

537: ,p_data => x_msg_data);
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO delete_tmpt_set2;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544: WHEN OTHERS THEN
545: ROLLBACK TO delete_tmpt_set2;

Line 548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

544: WHEN OTHERS THEN
545: ROLLBACK TO delete_tmpt_set2;
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
547: -- store SQL error message on message stack for caller
548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);
551: -- notify caller of an UNEXPECTED error
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 557: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

553: END delete_tmpt_set;
554:
555: PROCEDURE delete_tmpt_set(
556: p_api_version IN NUMBER
557: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
558: ,x_return_status OUT NOCOPY VARCHAR2
559: ,x_msg_count OUT NOCOPY NUMBER
560: ,x_msg_data OUT NOCOPY VARCHAR2
561: ,p_aesv_tbl IN aesv_tbl_type) IS

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

559: ,x_msg_count OUT NOCOPY NUMBER
560: ,x_msg_data OUT NOCOPY VARCHAR2
561: ,p_aesv_tbl IN aesv_tbl_type) IS
562: i NUMBER :=0;
563: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
564: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
565: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_set';
566: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
567: BEGIN

Line 564: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

560: ,x_msg_data OUT NOCOPY VARCHAR2
561: ,p_aesv_tbl IN aesv_tbl_type) IS
562: i NUMBER :=0;
563: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
564: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
565: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_set';
566: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
567: BEGIN
568: --Initialize the return status

Line 584: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

580: ,x_msg_count => x_msg_count
581: ,x_msg_data => x_msg_data
582: ,p_aesv_rec => l_aesv_tbl(i)
583: );
584: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
585: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
586: l_overall_status := x_return_status;
587: END IF;
588: END IF;

Line 585: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

581: ,x_msg_data => x_msg_data
582: ,p_aesv_rec => l_aesv_tbl(i)
583: );
584: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
585: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
586: l_overall_status := x_return_status;
587: END IF;
588: END IF;
589: EXIT WHEN (i = l_aesv_tbl.LAST);

Line 605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

601: EXCEPTION
602: WHEN FND_API.G_EXC_ERROR THEN
603: ROLLBACK TO delete_tmpt_set2;
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
606: ,p_count => x_msg_count
607: ,p_data => x_msg_data);
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_tmpt_set2;

Line 611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

607: ,p_data => x_msg_data);
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_tmpt_set2;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614: WHEN OTHERS THEN
615: ROLLBACK TO delete_tmpt_set2;

Line 618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

614: WHEN OTHERS THEN
615: ROLLBACK TO delete_tmpt_set2;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_set');
617: -- store SQL error message on message stack for caller
618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
619: ,p_count => x_msg_count
620: ,p_data => x_msg_data);
621: -- notify caller of an UNEXPECTED error
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 626: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: END delete_tmpt_set;
624:
625: PROCEDURE create_template(p_api_version IN NUMBER,
626: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
627: x_return_status OUT NOCOPY VARCHAR2,
628: x_msg_count OUT NOCOPY NUMBER,
629: x_msg_data OUT NOCOPY VARCHAR2,
630: p_avlv_rec IN avlv_rec_type,

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

628: x_msg_count OUT NOCOPY NUMBER,
629: x_msg_data OUT NOCOPY VARCHAR2,
630: p_avlv_rec IN avlv_rec_type,
631: x_avlv_rec OUT NOCOPY avlv_rec_type) IS
632: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
633: l_api_name CONSTANT VARCHAR2(30) := 'create_template';
634: l_avlv_rec avlv_rec_type := p_avlv_rec;
635: BEGIN
636: SAVEPOINT create_template2;

Line 676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO create_template2;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO create_template2;

Line 682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

678: ,p_data => x_msg_data);
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: ROLLBACK TO create_template2;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
683: ,p_count => x_msg_count
684: ,p_data => x_msg_data);
685: WHEN OTHERS THEN
686: ROLLBACK TO create_template2;

Line 689: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

685: WHEN OTHERS THEN
686: ROLLBACK TO create_template2;
687: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');
688: -- store SQL error message on message stack for caller
689: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
690: ,p_count => x_msg_count
691: ,p_data => x_msg_data);
692: -- notify caller of an UNEXPECTED error
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 698: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

694: END create_template;
695:
696: PROCEDURE create_template(
697: p_api_version IN NUMBER
698: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
699: ,x_return_status OUT NOCOPY VARCHAR2
700: ,x_msg_count OUT NOCOPY NUMBER
701: ,x_msg_data OUT NOCOPY VARCHAR2
702: ,p_avlv_tbl IN avlv_tbl_type

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

700: ,x_msg_count OUT NOCOPY NUMBER
701: ,x_msg_data OUT NOCOPY VARCHAR2
702: ,p_avlv_tbl IN avlv_tbl_type
703: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
705: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
706: l_api_name CONSTANT VARCHAR2(30) := 'create_template';
707: i NUMBER;
708: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;

Line 705: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

701: ,x_msg_data OUT NOCOPY VARCHAR2
702: ,p_avlv_tbl IN avlv_tbl_type
703: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
705: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
706: l_api_name CONSTANT VARCHAR2(30) := 'create_template';
707: i NUMBER;
708: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
709: BEGIN

Line 725: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

721: ,x_msg_count => x_msg_count
722: ,x_msg_data => x_msg_data
723: ,p_avlv_rec => l_avlv_tbl(i)
724: ,x_avlv_rec => x_avlv_tbl(i)); -- not possible thru this API
725: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
726: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
727: l_overall_status := x_return_status;
728: END IF;
729: END IF;

Line 726: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

722: ,x_msg_data => x_msg_data
723: ,p_avlv_rec => l_avlv_tbl(i)
724: ,x_avlv_rec => x_avlv_tbl(i)); -- not possible thru this API
725: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
726: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
727: l_overall_status := x_return_status;
728: END IF;
729: END IF;
730: EXIT WHEN (i = l_avlv_tbl.LAST);

Line 747: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

743: EXCEPTION
744: WHEN FND_API.G_EXC_ERROR THEN
745: ROLLBACK TO create_template2;
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
748: ,p_count => x_msg_count
749: ,p_data => x_msg_data);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO create_template2;

Line 753: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

749: ,p_data => x_msg_data);
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO create_template2;
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
754: ,p_count => x_msg_count
755: ,p_data => x_msg_data);
756: WHEN OTHERS THEN
757: ROLLBACK TO create_template2;

Line 760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

756: WHEN OTHERS THEN
757: ROLLBACK TO create_template2;
758: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_template');
759: -- store SQL error message on message stack for caller
760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
763: -- notify caller of an UNEXPECTED error
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 769: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

765: END create_template;
766:
767: PROCEDURE update_template(
768: p_api_version IN NUMBER
769: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
770: ,x_return_status OUT NOCOPY VARCHAR2
771: ,x_msg_count OUT NOCOPY NUMBER
772: ,x_msg_data OUT NOCOPY VARCHAR2
773: ,p_avlv_rec IN avlv_rec_type

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

771: ,x_msg_count OUT NOCOPY NUMBER
772: ,x_msg_data OUT NOCOPY VARCHAR2
773: ,p_avlv_rec IN avlv_rec_type
774: ,x_avlv_rec OUT NOCOPY avlv_rec_type) IS
775: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
776: l_api_name CONSTANT VARCHAR2(30) := 'update_template';
777: l_avlv_rec avlv_rec_type := p_avlv_rec;
778: BEGIN
779: SAVEPOINT update_template2;

Line 821: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

817: EXCEPTION
818: WHEN FND_API.G_EXC_ERROR THEN
819: ROLLBACK TO update_template2;
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
822: ,p_count => x_msg_count
823: ,p_data => x_msg_data);
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO update_template2;

Line 827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

823: ,p_data => x_msg_data);
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO update_template2;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
828: ,p_count => x_msg_count
829: ,p_data => x_msg_data);
830: WHEN OTHERS THEN
831: ROLLBACK TO update_template2;

Line 834: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

830: WHEN OTHERS THEN
831: ROLLBACK TO update_template2;
832: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
833: -- store SQL error message on message stack for caller
834: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
835: ,p_count => x_msg_count
836: ,p_data => x_msg_data);
837: -- notify caller of an UNEXPECTED error
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 843: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

839: END update_template;
840:
841: PROCEDURE update_template(
842: p_api_version IN NUMBER
843: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
844: ,x_return_status OUT NOCOPY VARCHAR2
845: ,x_msg_count OUT NOCOPY NUMBER
846: ,x_msg_data OUT NOCOPY VARCHAR2
847: ,p_avlv_tbl IN avlv_tbl_type

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

845: ,x_msg_count OUT NOCOPY NUMBER
846: ,x_msg_data OUT NOCOPY VARCHAR2
847: ,p_avlv_tbl IN avlv_tbl_type
848: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
851: l_api_name CONSTANT VARCHAR2(30) := 'update_template';
852: i NUMBER;
853: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;

Line 850: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

846: ,x_msg_data OUT NOCOPY VARCHAR2
847: ,p_avlv_tbl IN avlv_tbl_type
848: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
851: l_api_name CONSTANT VARCHAR2(30) := 'update_template';
852: i NUMBER;
853: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
854: BEGIN

Line 872: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

868: ,x_msg_data => x_msg_data
869: ,p_avlv_rec => l_avlv_tbl(i)
870: ,x_avlv_rec => x_avlv_tbl(i)
871: );
872: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
873: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: l_overall_status := x_return_status;
875: END IF;
876: END IF;

Line 873: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

869: ,p_avlv_rec => l_avlv_tbl(i)
870: ,x_avlv_rec => x_avlv_tbl(i)
871: );
872: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
873: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: l_overall_status := x_return_status;
875: END IF;
876: END IF;
877: EXIT WHEN (i = l_avlv_tbl.LAST);

Line 894: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

890: EXCEPTION
891: WHEN FND_API.G_EXC_ERROR THEN
892: ROLLBACK TO update_template2;
893: x_return_status := FND_API.G_RET_STS_ERROR;
894: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
895: ,p_count => x_msg_count
896: ,p_data => x_msg_data);
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO update_template2;

Line 900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

896: ,p_data => x_msg_data);
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: ROLLBACK TO update_template2;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
901: ,p_count => x_msg_count
902: ,p_data => x_msg_data);
903: WHEN OTHERS THEN
904: ROLLBACK TO update_template2;

Line 907: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

903: WHEN OTHERS THEN
904: ROLLBACK TO update_template2;
905: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_template');
906: -- store SQL error message on message stack for caller
907: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
908: ,p_count => x_msg_count
909: ,p_data => x_msg_data);
910: -- notify caller of an UNEXPECTED error
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 917: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

913:
914: --Put custom code for cascade delete by developer
915: PROCEDURE delete_template(
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_avlv_rec IN avlv_rec_type) IS

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

919: ,x_msg_count OUT NOCOPY NUMBER
920: ,x_msg_data OUT NOCOPY VARCHAR2
921: ,p_avlv_rec IN avlv_rec_type) IS
922: i NUMBER :=0;
923: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
924: l_api_name CONSTANT VARCHAR2(30) := 'delete_template';
925: l_avlv_rec avlv_rec_type := p_avlv_rec;
926: BEGIN
927: SAVEPOINT delete_template2;

Line 966: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: ROLLBACK TO delete_template2;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
967: ,p_count => x_msg_count
968: ,p_data => x_msg_data);
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO delete_template2;

Line 972: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

968: ,p_data => x_msg_data);
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: ROLLBACK TO delete_template2;
971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
973: ,p_count => x_msg_count
974: ,p_data => x_msg_data);
975: WHEN OTHERS THEN
976: ROLLBACK TO delete_template2;

Line 979: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

975: WHEN OTHERS THEN
976: ROLLBACK TO delete_template2;
977: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
978: -- store SQL error message on message stack for caller
979: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
980: ,p_count => x_msg_count
981: ,p_data => x_msg_data);
982: -- notify caller of an UNEXPECTED error
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 988: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

984: END delete_template;
985:
986: PROCEDURE delete_template(
987: p_api_version IN NUMBER
988: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
989: ,x_return_status OUT NOCOPY VARCHAR2
990: ,x_msg_count OUT NOCOPY NUMBER
991: ,x_msg_data OUT NOCOPY VARCHAR2
992: ,p_avlv_tbl IN avlv_tbl_type) IS

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

990: ,x_msg_count OUT NOCOPY NUMBER
991: ,x_msg_data OUT NOCOPY VARCHAR2
992: ,p_avlv_tbl IN avlv_tbl_type) IS
993: i NUMBER :=0;
994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
995: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
996: l_api_name CONSTANT VARCHAR2(30) := 'delete_template';
997: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
998: BEGIN

Line 995: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

991: ,x_msg_data OUT NOCOPY VARCHAR2
992: ,p_avlv_tbl IN avlv_tbl_type) IS
993: i NUMBER :=0;
994: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
995: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
996: l_api_name CONSTANT VARCHAR2(30) := 'delete_template';
997: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
998: BEGIN
999: --Initialize the return status

Line 1014: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1010: ,x_return_status => x_return_status
1011: ,x_msg_count => x_msg_count
1012: ,x_msg_data => x_msg_data
1013: ,p_avlv_rec => l_avlv_tbl(i));
1014: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1015: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1016: l_overall_status := x_return_status;
1017: END IF;
1018: END IF;

Line 1015: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1011: ,x_msg_count => x_msg_count
1012: ,x_msg_data => x_msg_data
1013: ,p_avlv_rec => l_avlv_tbl(i));
1014: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1015: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1016: l_overall_status := x_return_status;
1017: END IF;
1018: END IF;
1019: EXIT WHEN (i = l_avlv_tbl.LAST);

Line 1035: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1031: EXCEPTION
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: ROLLBACK TO delete_template2;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1036: ,p_count => x_msg_count
1037: ,p_data => x_msg_data);
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO delete_template2;

Line 1041: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1037: ,p_data => x_msg_data);
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO delete_template2;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1042: ,p_count => x_msg_count
1043: ,p_data => x_msg_data);
1044: WHEN OTHERS THEN
1045: ROLLBACK TO delete_template2;

Line 1048: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1044: WHEN OTHERS THEN
1045: ROLLBACK TO delete_template2;
1046: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_template');
1047: -- store SQL error message on message stack for caller
1048: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1049: ,p_count => x_msg_count
1050: ,p_data => x_msg_data);
1051: -- notify caller of an UNEXPECTED error
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1057: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1053: END delete_template;
1054:
1055: PROCEDURE create_tmpt_lines(
1056: p_api_version IN NUMBER
1057: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1058: ,x_return_status OUT NOCOPY VARCHAR2
1059: ,x_msg_count OUT NOCOPY NUMBER
1060: ,x_msg_data OUT NOCOPY VARCHAR2
1061: ,p_atlv_rec IN atlv_rec_type

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

1059: ,x_msg_count OUT NOCOPY NUMBER
1060: ,x_msg_data OUT NOCOPY VARCHAR2
1061: ,p_atlv_rec IN atlv_rec_type
1062: ,x_atlv_rec OUT NOCOPY atlv_rec_type) IS
1063: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1064: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_lines';
1065: l_atlv_rec atlv_rec_type := p_atlv_rec;
1066: BEGIN
1067: SAVEPOINT create_tmpt_lines2;

Line 1109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: ROLLBACK TO create_tmpt_lines2;
1108: x_return_status := FND_API.G_RET_STS_ERROR;
1109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1110: ,p_count => x_msg_count
1111: ,p_data => x_msg_data);
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ROLLBACK TO create_tmpt_lines2;

Line 1115: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1111: ,p_data => x_msg_data);
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ROLLBACK TO create_tmpt_lines2;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1116: ,p_count => x_msg_count
1117: ,p_data => x_msg_data);
1118: WHEN OTHERS THEN
1119: ROLLBACK TO create_tmpt_lines2;

Line 1122: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1118: WHEN OTHERS THEN
1119: ROLLBACK TO create_tmpt_lines2;
1120: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');
1121: -- store SQL error message on message stack for caller
1122: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1123: ,p_count => x_msg_count
1124: ,p_data => x_msg_data);
1125: -- notify caller of an UNEXPECTED error
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1127: END create_tmpt_lines;
1128:
1129: PROCEDURE create_tmpt_lines(
1130: p_api_version IN NUMBER
1131: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1132: ,x_return_status OUT NOCOPY VARCHAR2
1133: ,x_msg_count OUT NOCOPY NUMBER
1134: ,x_msg_data OUT NOCOPY VARCHAR2
1135: ,p_atlv_tbl IN atlv_tbl_type

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

1133: ,x_msg_count OUT NOCOPY NUMBER
1134: ,x_msg_data OUT NOCOPY VARCHAR2
1135: ,p_atlv_tbl IN atlv_tbl_type
1136: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
1137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1139: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_lines';
1140: i NUMBER;
1141: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;

Line 1138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1134: ,x_msg_data OUT NOCOPY VARCHAR2
1135: ,p_atlv_tbl IN atlv_tbl_type
1136: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
1137: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1138: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1139: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_lines';
1140: i NUMBER;
1141: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1142: BEGIN

Line 1160: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1156: ,x_msg_data => x_msg_data
1157: ,p_atlv_rec => l_atlv_tbl(i)
1158: ,x_atlv_rec => x_atlv_tbl(i)
1159: );
1160: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1161: l_overall_status := x_return_status;
1162: EXIT;
1163: END IF;
1164: EXIT WHEN (i = l_atlv_tbl.LAST);

Line 1181: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: ROLLBACK TO create_tmpt_lines2;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1182: ,p_count => x_msg_count
1183: ,p_data => x_msg_data);
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO create_tmpt_lines2;

Line 1187: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1183: ,p_data => x_msg_data);
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO create_tmpt_lines2;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1188: ,p_count => x_msg_count
1189: ,p_data => x_msg_data);
1190: WHEN OTHERS THEN
1191: ROLLBACK TO create_tmpt_lines2;

Line 1194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1190: WHEN OTHERS THEN
1191: ROLLBACK TO create_tmpt_lines2;
1192: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','create_tmpt_lines');
1193: -- store SQL error message on message stack for caller
1194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1195: ,p_count => x_msg_count
1196: ,p_data => x_msg_data);
1197: -- notify caller of an UNEXPECTED error
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1203: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1199: END create_tmpt_lines;
1200:
1201: PROCEDURE update_tmpt_lines(
1202: p_api_version IN NUMBER
1203: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1204: ,x_return_status OUT NOCOPY VARCHAR2
1205: ,x_msg_count OUT NOCOPY NUMBER
1206: ,x_msg_data OUT NOCOPY VARCHAR2
1207: ,p_atlv_rec IN atlv_rec_type

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

1205: ,x_msg_count OUT NOCOPY NUMBER
1206: ,x_msg_data OUT NOCOPY VARCHAR2
1207: ,p_atlv_rec IN atlv_rec_type
1208: ,x_atlv_rec OUT NOCOPY atlv_rec_type) IS
1209: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1210: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_lines';
1211: l_atlv_rec atlv_rec_type := p_atlv_rec;
1212: BEGIN
1213: SAVEPOINT update_tmpt_lines2;

Line 1255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1251: EXCEPTION
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO update_tmpt_lines2;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1256: ,p_count => x_msg_count
1257: ,p_data => x_msg_data);
1258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1259: ROLLBACK TO update_tmpt_lines2;

Line 1261: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1257: ,p_data => x_msg_data);
1258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1259: ROLLBACK TO update_tmpt_lines2;
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1262: ,p_count => x_msg_count
1263: ,p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: ROLLBACK TO update_tmpt_lines2;

Line 1268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1264: WHEN OTHERS THEN
1265: ROLLBACK TO update_tmpt_lines2;
1266: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
1267: -- store SQL error message on message stack for caller
1268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1269: ,p_count => x_msg_count
1270: ,p_data => x_msg_data);
1271: -- notify caller of an UNEXPECTED error
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1277: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1273: END update_tmpt_lines;
1274:
1275: PROCEDURE update_tmpt_lines(
1276: p_api_version IN NUMBER
1277: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1278: ,x_return_status OUT NOCOPY VARCHAR2
1279: ,x_msg_count OUT NOCOPY NUMBER
1280: ,x_msg_data OUT NOCOPY VARCHAR2
1281: ,p_atlv_tbl IN atlv_tbl_type

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

1279: ,x_msg_count OUT NOCOPY NUMBER
1280: ,x_msg_data OUT NOCOPY VARCHAR2
1281: ,p_atlv_tbl IN atlv_tbl_type
1282: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
1283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1284: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1285: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_lines';
1286: i NUMBER;
1287: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;

Line 1284: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1280: ,x_msg_data OUT NOCOPY VARCHAR2
1281: ,p_atlv_tbl IN atlv_tbl_type
1282: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
1283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1284: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1285: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_lines';
1286: i NUMBER;
1287: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1288: BEGIN

Line 1306: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1302: ,x_msg_data => x_msg_data
1303: ,p_atlv_rec => l_atlv_tbl(i)
1304: ,x_atlv_rec => x_atlv_tbl(i)
1305: );
1306: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1307: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1308: l_overall_status := x_return_status;
1309: END IF;
1310: END IF;

Line 1307: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1303: ,p_atlv_rec => l_atlv_tbl(i)
1304: ,x_atlv_rec => x_atlv_tbl(i)
1305: );
1306: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1307: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1308: l_overall_status := x_return_status;
1309: END IF;
1310: END IF;
1311: EXIT WHEN (i = l_atlv_tbl.LAST);

Line 1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1324: EXCEPTION
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: ROLLBACK TO update_tmpt_lines2;
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1329: ,p_count => x_msg_count
1330: ,p_data => x_msg_data);
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: ROLLBACK TO update_tmpt_lines2;

Line 1334: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1330: ,p_data => x_msg_data);
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: ROLLBACK TO update_tmpt_lines2;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1335: ,p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: WHEN OTHERS THEN
1338: ROLLBACK TO update_tmpt_lines2;

Line 1341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1337: WHEN OTHERS THEN
1338: ROLLBACK TO update_tmpt_lines2;
1339: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','update_tmpt_lines');
1340: -- store SQL error message on message stack for caller
1341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1342: ,p_count => x_msg_count
1343: ,p_data => x_msg_data);
1344: -- notify caller of an UNEXPECTED error
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1351: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1347:
1348: --Put custom code for cascade delete by developer
1349: PROCEDURE delete_tmpt_lines(
1350: p_api_version IN NUMBER
1351: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1352: ,x_return_status OUT NOCOPY VARCHAR2
1353: ,x_msg_count OUT NOCOPY NUMBER
1354: ,x_msg_data OUT NOCOPY VARCHAR2
1355: ,p_atlv_rec IN atlv_rec_type) IS

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

1353: ,x_msg_count OUT NOCOPY NUMBER
1354: ,x_msg_data OUT NOCOPY VARCHAR2
1355: ,p_atlv_rec IN atlv_rec_type) IS
1356: i NUMBER :=0;
1357: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1358: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_lines';
1359: l_atlv_rec atlv_rec_type := p_atlv_rec;
1360: BEGIN
1361: SAVEPOINT delete_tmpt_lines2;

Line 1400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1396: EXCEPTION
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: ROLLBACK TO delete_tmpt_lines2;
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1401: ,p_count => x_msg_count
1402: ,p_data => x_msg_data);
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO delete_tmpt_lines2;

Line 1406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1402: ,p_data => x_msg_data);
1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1404: ROLLBACK TO delete_tmpt_lines2;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1407: ,p_count => x_msg_count
1408: ,p_data => x_msg_data);
1409: WHEN OTHERS THEN
1410: ROLLBACK TO delete_tmpt_lines2;

Line 1413: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1409: WHEN OTHERS THEN
1410: ROLLBACK TO delete_tmpt_lines2;
1411: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
1412: -- store SQL error message on message stack for caller
1413: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1414: ,p_count => x_msg_count
1415: ,p_data => x_msg_data);
1416: -- notify caller of an UNEXPECTED error
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1422: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1418: END delete_tmpt_lines;
1419:
1420: PROCEDURE delete_tmpt_lines(
1421: p_api_version IN NUMBER
1422: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1423: ,x_return_status OUT NOCOPY VARCHAR2
1424: ,x_msg_count OUT NOCOPY NUMBER
1425: ,x_msg_data OUT NOCOPY VARCHAR2
1426: ,p_atlv_tbl IN atlv_tbl_type) IS

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

1424: ,x_msg_count OUT NOCOPY NUMBER
1425: ,x_msg_data OUT NOCOPY VARCHAR2
1426: ,p_atlv_tbl IN atlv_tbl_type) IS
1427: i NUMBER :=0;
1428: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1429: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1430: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_lines';
1431: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1432: BEGIN

Line 1429: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1425: ,x_msg_data OUT NOCOPY VARCHAR2
1426: ,p_atlv_tbl IN atlv_tbl_type) IS
1427: i NUMBER :=0;
1428: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1429: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1430: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_lines';
1431: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1432: BEGIN
1433: --Initialize the return status

Line 1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1444: ,x_return_status => x_return_status
1445: ,x_msg_count => x_msg_count
1446: ,x_msg_data => x_msg_data
1447: ,p_atlv_rec => l_atlv_tbl(i));
1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1449: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: l_overall_status := x_return_status;
1451: END IF;
1452: END IF;

Line 1449: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1445: ,x_msg_count => x_msg_count
1446: ,x_msg_data => x_msg_data
1447: ,p_atlv_rec => l_atlv_tbl(i));
1448: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1449: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: l_overall_status := x_return_status;
1451: END IF;
1452: END IF;
1453: EXIT WHEN (i = l_atlv_tbl.LAST);

Line 1469: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1465: EXCEPTION
1466: WHEN FND_API.G_EXC_ERROR THEN
1467: ROLLBACK TO delete_tmpt_lines2;
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1470: ,p_count => x_msg_count
1471: ,p_data => x_msg_data);
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: ROLLBACK TO delete_tmpt_lines2;

Line 1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1471: ,p_data => x_msg_data);
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: ROLLBACK TO delete_tmpt_lines2;
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: WHEN OTHERS THEN
1479: ROLLBACK TO delete_tmpt_lines2;

Line 1482: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1478: WHEN OTHERS THEN
1479: ROLLBACK TO delete_tmpt_lines2;
1480: FND_MSG_PUB.ADD_EXC_MSG('OKL_PROCESS_TMPT_SET_PUB','delete_tmpt_lines');
1481: -- store SQL error message on message stack for caller
1482: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1483: ,p_count => x_msg_count
1484: ,p_data => x_msg_data);
1485: -- notify caller of an UNEXPECTED error
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;