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 FND_API

Line 30: x_return_status := FND_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;
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: -- customer pre-processing
32: -- vertical industry-preprocessing
33: -- call complex entity API
34: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set

Line 62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

58: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set ');
59: END;
60: END IF;
61: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
63: RAISE FND_API.G_EXC_ERROR;
64: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;

Line 63: RAISE FND_API.G_EXC_ERROR;

59: END;
60: END IF;
61: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
63: RAISE FND_API.G_EXC_ERROR;
64: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67: l_aesv_rec := x_aesv_rec;

Line 64: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

60: END IF;
61: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
63: RAISE FND_API.G_EXC_ERROR;
64: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67: l_aesv_rec := x_aesv_rec;
68: l_avlv_tbl := x_avlv_tbl;

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
62: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
63: RAISE FND_API.G_EXC_ERROR;
64: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67: l_aesv_rec := x_aesv_rec;
68: l_avlv_tbl := x_avlv_tbl;
69: l_atlv_tbl := x_atlv_tbl;

Line 73: WHEN FND_API.G_EXC_ERROR THEN

69: l_atlv_tbl := x_atlv_tbl;
70: -- vertical industry-post-processing
71: -- customer post-processing
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

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71: -- customer post-processing
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

Line 79: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
94: END create_tmpt_set;
95:
96: PROCEDURE create_tmpt_set(
97: p_api_version IN NUMBER

Line 111: x_return_status := FND_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;
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: -- customer pre-processing
113: -- vertical industry-preprocessing
114: -- call complex entity API
115: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set

Line 141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

137: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set ');
138: END;
139: END IF;
140: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142: RAISE FND_API.G_EXC_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;

Line 142: RAISE FND_API.G_EXC_ERROR;

138: END;
139: END IF;
140: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142: RAISE FND_API.G_EXC_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: l_aesv_rec := x_aesv_rec;

Line 143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

139: END IF;
140: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142: RAISE FND_API.G_EXC_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: l_aesv_rec := x_aesv_rec;
147: -- vertical industry-post-processing

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_set
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142: RAISE FND_API.G_EXC_ERROR;
143: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146: l_aesv_rec := x_aesv_rec;
147: -- vertical industry-post-processing
148: -- customer post-processing

Line 150: WHEN FND_API.G_EXC_ERROR THEN

146: l_aesv_rec := x_aesv_rec;
147: -- vertical industry-post-processing
148: -- customer post-processing
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

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148: -- customer post-processing
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

Line 156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
171: END create_tmpt_set;
172:
173: PROCEDURE create_tmpt_set(
174: p_api_version IN NUMBER

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
190: -- customer pre-processing
191: -- vertical industry-preprocessing
192: IF (l_aesv_tbl.COUNT > 0) THEN
193: i := l_aesv_tbl.FIRST;

Line 215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

211: i := l_aesv_tbl.NEXT(i);
212: END LOOP;
213: END IF;
214: x_return_status := l_overall_status;
215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;

Line 216: RAISE FND_API.G_EXC_ERROR;

212: END LOOP;
213: END IF;
214: x_return_status := l_overall_status;
215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: l_aesv_tbl := x_aesv_tbl;

Line 217: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

213: END IF;
214: x_return_status := l_overall_status;
215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: l_aesv_tbl := x_aesv_tbl;
221: -- vertical industry-post-processing

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214: x_return_status := l_overall_status;
215: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
216: RAISE FND_API.G_EXC_ERROR;
217: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END IF;
220: l_aesv_tbl := x_aesv_tbl;
221: -- vertical industry-post-processing
222: -- customer post-processing

Line 224: WHEN FND_API.G_EXC_ERROR THEN

220: l_aesv_tbl := x_aesv_tbl;
221: -- vertical industry-post-processing
222: -- customer post-processing
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

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

222: -- customer post-processing
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

Line 230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
245: END create_tmpt_set;
246:
247: -- Object type procedure for update
248: PROCEDURE update_tmpt_set(

Line 267: x_return_status := FND_API.G_RET_STS_SUCCESS;

263: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
264: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
265: BEGIN
266: SAVEPOINT update_tmpt_set2;
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268: -- customer pre-processing
269: -- vertical industry-preprocessing
270: -- call complex entity API
271: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set

Line 300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

296: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set ');
297: END;
298: END IF;
299: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;

Line 301: RAISE FND_API.G_EXC_ERROR;

297: END;
298: END IF;
299: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: l_aesv_rec := x_aesv_rec;

Line 302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

298: END IF;
299: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: l_aesv_rec := x_aesv_rec;
306: l_avlv_tbl := x_avlv_tbl;

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: l_aesv_rec := x_aesv_rec;
306: l_avlv_tbl := x_avlv_tbl;
307: l_atlv_tbl := x_atlv_tbl;

Line 311: WHEN FND_API.G_EXC_ERROR THEN

307: l_atlv_tbl := x_atlv_tbl;
308: -- vertical industry-post processing
309: -- customer post-processing
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

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: -- customer post-processing
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

Line 317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
332: END update_tmpt_set;
333:
334: PROCEDURE update_tmpt_set(
335: p_api_version IN NUMBER

Line 347: x_return_status := FND_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;
347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348: -- customer pre-processing
349: -- vertical industry-preprocessing
350: -- call complex entity API
351: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set

Line 376: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

372: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set ');
373: END;
374: END IF;
375: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
376: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;

Line 377: RAISE FND_API.G_EXC_ERROR;

373: END;
374: END IF;
375: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
376: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: l_aesv_rec := x_aesv_rec;

Line 378: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

374: END IF;
375: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
376: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: l_aesv_rec := x_aesv_rec;
382: -- vertical industry-post-processing

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_set
376: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: l_aesv_rec := x_aesv_rec;
382: -- vertical industry-post-processing
383: -- customer post-processing

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: l_aesv_rec := x_aesv_rec;
382: -- vertical industry-post-processing
383: -- customer post-processing
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

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: -- customer post-processing
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

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
406: END update_tmpt_set;
407:
408:
409: PROCEDURE update_tmpt_set(

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
422: BEGIN
423: --Initialize the return status
424: SAVEPOINT update_tmpt_set2;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426: -- customer pre-processing
427: -- vertical industry-preprocessing
428: IF (l_aesv_tbl.COUNT > 0) THEN
429: i := l_aesv_tbl.FIRST;

Line 450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

446: i := l_aesv_tbl.NEXT(i);
447: END LOOP;
448: END IF;
449: x_return_status := l_overall_Status;
450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;

Line 451: RAISE FND_API.G_EXC_ERROR;

447: END LOOP;
448: END IF;
449: x_return_status := l_overall_Status;
450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: l_aesv_tbl := x_aesv_tbl;

Line 452: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

448: END IF;
449: x_return_status := l_overall_Status;
450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: l_aesv_tbl := x_aesv_tbl;
456: -- vertical industry-post-processing

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: x_return_status := l_overall_Status;
450: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
451: RAISE FND_API.G_EXC_ERROR;
452: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: l_aesv_tbl := x_aesv_tbl;
456: -- vertical industry-post-processing
457: -- customer post-processing

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455: l_aesv_tbl := x_aesv_tbl;
456: -- vertical industry-post-processing
457: -- customer post-processing
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

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457: -- customer post-processing
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

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
480: END update_tmpt_set;
481:
482: --Put custom code for cascade delete by developer
483: PROCEDURE delete_tmpt_set(

Line 496: x_return_status := FND_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;
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: -- customer pre-processing
498: -- vertical industry-preprocessing
499: -- call complex entity API
500: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set

Line 524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

520: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set ');
521: END;
522: END IF;
523: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set
524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;

Line 525: RAISE FND_API.G_EXC_ERROR;

521: END;
522: END IF;
523: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set
524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: -- vertical industry-post-processing

Line 526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

522: END IF;
523: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set
524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: -- vertical industry-post-processing
530: -- customer post-processing

Line 527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

523: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_set
524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
525: RAISE FND_API.G_EXC_ERROR;
526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: -- vertical industry-post-processing
530: -- customer post-processing
531: EXCEPTION

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: END IF;
529: -- vertical industry-post-processing
530: -- customer post-processing
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

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: -- customer post-processing
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

Line 538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
553: END delete_tmpt_set;
554:
555: PROCEDURE delete_tmpt_set(
556: p_api_version IN NUMBER

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS;

566: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
567: BEGIN
568: --Initialize the return status
569: SAVEPOINT delete_tmpt_set2;
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571: -- customer pre-processing
572: -- vertical industry-preprocessing
573: IF (l_aesv_tbl.COUNT > 0) THEN
574: i := l_aesv_tbl.FIRST;

Line 594: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

590: i := l_aesv_tbl.NEXT(i);
591: END LOOP;
592: END IF;
593: x_return_status := l_overall_status;
594: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: END LOOP;
592: END IF;
593: x_return_status := l_overall_status;
594: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: -- vertical industry-post-processing

Line 596: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

592: END IF;
593: x_return_status := l_overall_status;
594: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: -- vertical industry-post-processing
600: -- customer post-processing

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: x_return_status := l_overall_status;
594: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: -- vertical industry-post-processing
600: -- customer post-processing
601: EXCEPTION

Line 602: WHEN FND_API.G_EXC_ERROR THEN

598: END IF;
599: -- vertical industry-post-processing
600: -- customer post-processing
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

Line 604: x_return_status := FND_API.G_RET_STS_ERROR;

600: -- customer post-processing
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

Line 608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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,

Line 637: x_return_status := FND_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;
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638: -- customer pre-processing
639: -- vertical industry-preprocessing
640: -- call complex entity API
641: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_template

Line 664: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

660: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.create_template ');
661: END;
662: END IF;
663: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_template
664: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;

Line 665: RAISE FND_API.G_EXC_ERROR;

661: END;
662: END IF;
663: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_template
664: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669: l_avlv_rec := x_avlv_rec;

Line 666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

662: END IF;
663: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_template
664: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669: l_avlv_rec := x_avlv_rec;
670: -- vertical industry-post-processing

Line 667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

663: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_template
664: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
665: RAISE FND_API.G_EXC_ERROR;
666: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669: l_avlv_rec := x_avlv_rec;
670: -- vertical industry-post-processing
671: -- customer post-processing

Line 673: WHEN FND_API.G_EXC_ERROR THEN

669: l_avlv_rec := x_avlv_rec;
670: -- vertical industry-post-processing
671: -- customer post-processing
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

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: -- customer post-processing
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

Line 679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
694: END create_template;
695:
696: PROCEDURE create_template(
697: p_api_version IN NUMBER

Line 712: x_return_status := FND_API.G_RET_STS_SUCCESS;

708: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
709: BEGIN
710: --Initialize the return status
711: SAVEPOINT create_template2;
712: x_return_status := FND_API.G_RET_STS_SUCCESS;
713: -- customer pre-processing
714: -- vertical industry-preprocessing
715: IF (l_avlv_tbl.COUNT > 0) THEN
716: i := l_avlv_tbl.FIRST;

Line 735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

731: i := l_avlv_tbl.NEXT(i);
732: END LOOP;
733: END IF;
734: x_return_status := l_overall_status ;
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;

Line 736: RAISE FND_API.G_EXC_ERROR;

732: END LOOP;
733: END IF;
734: x_return_status := l_overall_status ;
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740: l_avlv_tbl := x_avlv_tbl;

Line 737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

733: END IF;
734: x_return_status := l_overall_status ;
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740: l_avlv_tbl := x_avlv_tbl;
741: -- vertical industry-post-processing

Line 738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

734: x_return_status := l_overall_status ;
735: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
736: RAISE FND_API.G_EXC_ERROR;
737: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
739: END IF;
740: l_avlv_tbl := x_avlv_tbl;
741: -- vertical industry-post-processing
742: -- customer post-processing

Line 744: WHEN FND_API.G_EXC_ERROR THEN

740: l_avlv_tbl := x_avlv_tbl;
741: -- vertical industry-post-processing
742: -- customer post-processing
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

Line 746: x_return_status := FND_API.G_RET_STS_ERROR;

742: -- customer post-processing
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

Line 750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
765: END create_template;
766:
767: PROCEDURE update_template(
768: p_api_version IN NUMBER

Line 780: x_return_status := FND_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;
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781: -- customer pre-processing
782: -- vertical industry-preprocessing
783: -- call complex entity API
784: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_template

Line 809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

805: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_template ');
806: END;
807: END IF;
808: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_template
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;

Line 810: RAISE FND_API.G_EXC_ERROR;

806: END;
807: END IF;
808: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_template
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: l_avlv_rec := x_avlv_rec;

Line 811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

807: END IF;
808: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_template
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: l_avlv_rec := x_avlv_rec;
815: -- vertical industry-post-processing

Line 812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

808: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_template
809: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
813: END IF;
814: l_avlv_rec := x_avlv_rec;
815: -- vertical industry-post-processing
816: -- customer post-processing

Line 818: WHEN FND_API.G_EXC_ERROR THEN

814: l_avlv_rec := x_avlv_rec;
815: -- vertical industry-post-processing
816: -- customer post-processing
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

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816: -- customer post-processing
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

Line 824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
839: END update_template;
840:
841: PROCEDURE update_template(
842: p_api_version IN NUMBER

Line 857: x_return_status := FND_API.G_RET_STS_SUCCESS;

853: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
854: BEGIN
855: --Initialize the return status
856: SAVEPOINT update_template2;
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858: -- customer pre-processing
859: -- vertical industry-preprocessing
860: IF (l_avlv_tbl.COUNT > 0) THEN
861: i := l_avlv_tbl.FIRST;

Line 882: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

878: i := l_avlv_tbl.NEXT(i);
879: END LOOP;
880: END IF;
881: x_return_status := l_overall_status;
882: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
883: RAISE FND_API.G_EXC_ERROR;
884: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;

Line 883: RAISE FND_API.G_EXC_ERROR;

879: END LOOP;
880: END IF;
881: x_return_status := l_overall_status;
882: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
883: RAISE FND_API.G_EXC_ERROR;
884: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887: l_avlv_tbl := x_avlv_tbl;

Line 884: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

880: END IF;
881: x_return_status := l_overall_status;
882: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
883: RAISE FND_API.G_EXC_ERROR;
884: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887: l_avlv_tbl := x_avlv_tbl;
888: -- vertical industry-post-processing

Line 885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

881: x_return_status := l_overall_status;
882: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
883: RAISE FND_API.G_EXC_ERROR;
884: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886: END IF;
887: l_avlv_tbl := x_avlv_tbl;
888: -- vertical industry-post-processing
889: -- customer post-processing

Line 891: WHEN FND_API.G_EXC_ERROR THEN

887: l_avlv_tbl := x_avlv_tbl;
888: -- vertical industry-post-processing
889: -- customer post-processing
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

Line 893: x_return_status := FND_API.G_RET_STS_ERROR;

889: -- customer post-processing
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

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
912: END update_template;
913:
914: --Put custom code for cascade delete by developer
915: PROCEDURE delete_template(

Line 928: x_return_status := FND_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;
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929: -- customer pre-processing
930: -- vertical industry-preprocessing
931: -- call complex entity API
932: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_template

Line 955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

951: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_template ');
952: END;
953: END IF;
954: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_template
955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
956: RAISE FND_API.G_EXC_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;

Line 956: RAISE FND_API.G_EXC_ERROR;

952: END;
953: END IF;
954: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_template
955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
956: RAISE FND_API.G_EXC_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960: -- vertical industry-post-processing

Line 957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

953: END IF;
954: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_template
955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
956: RAISE FND_API.G_EXC_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960: -- vertical industry-post-processing
961: -- customer post-processing

Line 958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_template
955: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
956: RAISE FND_API.G_EXC_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960: -- vertical industry-post-processing
961: -- customer post-processing
962: EXCEPTION

Line 963: WHEN FND_API.G_EXC_ERROR THEN

959: END IF;
960: -- vertical industry-post-processing
961: -- customer post-processing
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

Line 965: x_return_status := FND_API.G_RET_STS_ERROR;

961: -- customer post-processing
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

Line 969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
984: END delete_template;
985:
986: PROCEDURE delete_template(
987: p_api_version IN NUMBER

Line 1001: x_return_status := FND_API.G_RET_STS_SUCCESS;

997: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
998: BEGIN
999: --Initialize the return status
1000: SAVEPOINT delete_template2;
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002: -- customer pre-processing
1003: -- vertical industry-preprocessing
1004: IF (l_avlv_tbl.COUNT > 0) THEN
1005: i := l_avlv_tbl.FIRST;

Line 1024: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1020: i := l_avlv_tbl.NEXT(i);
1021: END LOOP;
1022: END IF;
1023: x_return_status := l_overall_status;
1024: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1025: RAISE FND_API.G_EXC_ERROR;
1026: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;

Line 1025: RAISE FND_API.G_EXC_ERROR;

1021: END LOOP;
1022: END IF;
1023: x_return_status := l_overall_status;
1024: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1025: RAISE FND_API.G_EXC_ERROR;
1026: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029: -- vertical industry-post-processing

Line 1026: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1022: END IF;
1023: x_return_status := l_overall_status;
1024: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1025: RAISE FND_API.G_EXC_ERROR;
1026: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029: -- vertical industry-post-processing
1030: -- customer post-processing

Line 1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1023: x_return_status := l_overall_status;
1024: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1025: RAISE FND_API.G_EXC_ERROR;
1026: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: END IF;
1029: -- vertical industry-post-processing
1030: -- customer post-processing
1031: EXCEPTION

Line 1032: WHEN FND_API.G_EXC_ERROR THEN

1028: END IF;
1029: -- vertical industry-post-processing
1030: -- customer post-processing
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

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: -- customer post-processing
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

Line 1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1053: END delete_template;
1054:
1055: PROCEDURE create_tmpt_lines(
1056: p_api_version IN NUMBER

Line 1068: x_return_status := FND_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;
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;
1069: -- customer pre-processing
1070: -- vertical industry-preprocessing
1071: -- call complex entity API
1072: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_lines

Line 1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1093: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.create_tmpt_lines ');
1094: END;
1095: END IF;
1096: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_lines
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: END;
1095: END IF;
1096: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_lines
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102: l_atlv_rec := x_atlv_rec;

Line 1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1095: END IF;
1096: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_lines
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102: l_atlv_rec := x_atlv_rec;
1103: -- vertical industry-post-processing

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1096: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.create_tmpt_lines
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: END IF;
1102: l_atlv_rec := x_atlv_rec;
1103: -- vertical industry-post-processing
1104: -- customer post-processing

Line 1106: WHEN FND_API.G_EXC_ERROR THEN

1102: l_atlv_rec := x_atlv_rec;
1103: -- vertical industry-post-processing
1104: -- customer post-processing
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

Line 1108: x_return_status := FND_API.G_RET_STS_ERROR;

1104: -- customer post-processing
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

Line 1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1127: END create_tmpt_lines;
1128:
1129: PROCEDURE create_tmpt_lines(
1130: p_api_version IN NUMBER

Line 1145: x_return_status := FND_API.G_RET_STS_SUCCESS;

1141: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1142: BEGIN
1143: --Initialize the return status
1144: SAVEPOINT create_tmpt_lines2;
1145: x_return_status := FND_API.G_RET_STS_SUCCESS;
1146: -- customer pre-processing
1147: -- vertical industry-preprocessing
1148: IF (l_atlv_tbl.COUNT > 0) THEN
1149: i := l_atlv_tbl.FIRST;

Line 1169: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1165: i := l_atlv_tbl.NEXT(i);
1166: END LOOP;
1167: END IF;
1168: x_return_status := l_overall_Status;
1169: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166: END LOOP;
1167: END IF;
1168: x_return_status := l_overall_Status;
1169: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: l_atlv_tbl := x_atlv_tbl;

Line 1171: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1167: END IF;
1168: x_return_status := l_overall_Status;
1169: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: l_atlv_tbl := x_atlv_tbl;
1175: -- vertical industry-post-processing

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: x_return_status := l_overall_Status;
1169: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174: l_atlv_tbl := x_atlv_tbl;
1175: -- vertical industry-post-processing
1176: -- customer post-processing

Line 1178: WHEN FND_API.G_EXC_ERROR THEN

1174: l_atlv_tbl := x_atlv_tbl;
1175: -- vertical industry-post-processing
1176: -- customer post-processing
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

Line 1180: x_return_status := FND_API.G_RET_STS_ERROR;

1176: -- customer post-processing
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

Line 1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1199: END create_tmpt_lines;
1200:
1201: PROCEDURE update_tmpt_lines(
1202: p_api_version IN NUMBER

Line 1214: x_return_status := FND_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;
1214: x_return_status := FND_API.G_RET_STS_SUCCESS;
1215: -- customer pre-processing
1216: -- vertical industry-preprocessing
1217: -- call complex entity API
1218: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines

Line 1243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1239: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines ');
1240: END;
1241: END IF;
1242: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines
1243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: END IF;

Line 1244: RAISE FND_API.G_EXC_ERROR;

1240: END;
1241: END IF;
1242: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines
1243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: END IF;
1248: l_atlv_rec := x_atlv_rec;

Line 1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1241: END IF;
1242: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines
1243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: END IF;
1248: l_atlv_rec := x_atlv_rec;
1249: -- vertical industry-post-processing

Line 1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1242: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.update_tmpt_lines
1243: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247: END IF;
1248: l_atlv_rec := x_atlv_rec;
1249: -- vertical industry-post-processing
1250: -- customer post-processing

Line 1252: WHEN FND_API.G_EXC_ERROR THEN

1248: l_atlv_rec := x_atlv_rec;
1249: -- vertical industry-post-processing
1250: -- customer post-processing
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

Line 1254: x_return_status := FND_API.G_RET_STS_ERROR;

1250: -- customer post-processing
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

Line 1258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1273: END update_tmpt_lines;
1274:
1275: PROCEDURE update_tmpt_lines(
1276: p_api_version IN NUMBER

Line 1291: x_return_status := FND_API.G_RET_STS_SUCCESS;

1287: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1288: BEGIN
1289: --Initialize the return status
1290: SAVEPOINT update_tmpt_lines2;
1291: x_return_status := FND_API.G_RET_STS_SUCCESS;
1292: -- customer pre-processing
1293: -- vertical industry-preprocessing
1294: IF (l_atlv_tbl.COUNT > 0) THEN
1295: i := l_atlv_tbl.FIRST;

Line 1316: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1312: i := l_atlv_tbl.NEXT(i);
1313: END LOOP;
1314: END IF;
1315: x_return_status := l_overall_status;
1316: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;

Line 1317: RAISE FND_API.G_EXC_ERROR;

1313: END LOOP;
1314: END IF;
1315: x_return_status := l_overall_status;
1316: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: l_atlv_tbl := x_atlv_tbl;

Line 1318: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1314: END IF;
1315: x_return_status := l_overall_status;
1316: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: l_atlv_tbl := x_atlv_tbl;
1322: -- vertical industry-post-processing

Line 1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1315: x_return_status := l_overall_status;
1316: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: l_atlv_tbl := x_atlv_tbl;
1322: -- vertical industry-post-processing
1323: -- customer post-processing

Line 1325: WHEN FND_API.G_EXC_ERROR THEN

1321: l_atlv_tbl := x_atlv_tbl;
1322: -- vertical industry-post-processing
1323: -- customer post-processing
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

Line 1327: x_return_status := FND_API.G_RET_STS_ERROR;

1323: -- customer post-processing
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

Line 1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1346: END update_tmpt_lines;
1347:
1348: --Put custom code for cascade delete by developer
1349: PROCEDURE delete_tmpt_lines(

Line 1362: x_return_status := FND_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;
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363: -- customer pre-processing
1364: -- vertical industry-preprocessing
1365: -- call complex entity API
1366: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines

Line 1389: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1385: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTMSB.pls call OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines ');
1386: END;
1387: END IF;
1388: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines
1389: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: END;
1387: END IF;
1388: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines
1389: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: -- vertical industry-post-processing

Line 1391: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1387: END IF;
1388: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines
1389: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: -- vertical industry-post-processing
1395: -- customer post-processing

Line 1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1388: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.delete_tmpt_lines
1389: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: -- vertical industry-post-processing
1395: -- customer post-processing
1396: EXCEPTION

Line 1397: WHEN FND_API.G_EXC_ERROR THEN

1393: END IF;
1394: -- vertical industry-post-processing
1395: -- customer post-processing
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

Line 1399: x_return_status := FND_API.G_RET_STS_ERROR;

1395: -- customer post-processing
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

Line 1403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1418: END delete_tmpt_lines;
1419:
1420: PROCEDURE delete_tmpt_lines(
1421: p_api_version IN NUMBER

Line 1435: x_return_status := FND_API.G_RET_STS_SUCCESS;

1431: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
1432: BEGIN
1433: --Initialize the return status
1434: SAVEPOINT delete_tmpt_lines2;
1435: x_return_status := FND_API.G_RET_STS_SUCCESS;
1436: -- customer pre-processing
1437: -- vertical industry-preprocessing
1438: IF (l_atlv_tbl.COUNT > 0) THEN
1439: i := l_atlv_tbl.FIRST;

Line 1458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1454: i := l_atlv_tbl.NEXT(i);
1455: END LOOP;
1456: END IF;
1457: x_return_status := l_overall_status;
1458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1459: RAISE FND_API.G_EXC_ERROR;
1460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;

Line 1459: RAISE FND_API.G_EXC_ERROR;

1455: END LOOP;
1456: END IF;
1457: x_return_status := l_overall_status;
1458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1459: RAISE FND_API.G_EXC_ERROR;
1460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463: -- vertical industry-post-processing

Line 1460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1456: END IF;
1457: x_return_status := l_overall_status;
1458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1459: RAISE FND_API.G_EXC_ERROR;
1460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463: -- vertical industry-post-processing
1464: -- customer post-processing

Line 1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1457: x_return_status := l_overall_status;
1458: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1459: RAISE FND_API.G_EXC_ERROR;
1460: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463: -- vertical industry-post-processing
1464: -- customer post-processing
1465: EXCEPTION

Line 1466: WHEN FND_API.G_EXC_ERROR THEN

1462: END IF;
1463: -- vertical industry-post-processing
1464: -- customer post-processing
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

Line 1468: x_return_status := FND_API.G_RET_STS_ERROR;

1464: -- customer post-processing
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

Line 1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
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

Line 1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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

Line 1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1487: END delete_tmpt_lines;
1488:
1489: /* This API Takes 'From Template Set ID' and 'To Template Set ID'
1490: as parameters and copies all the templates and Template Line

Line 1509: x_return_status := FND_API.G_RET_STS_SUCCESS;

1505: l_aes_id_to NUMBER := p_aes_id_to;
1506: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1507: BEGIN
1508: SAVEPOINT COPY_TMPL_SET2;
1509: x_return_status := FND_API.G_RET_STS_SUCCESS;
1510: -- customer pre-processing
1511: -- Run the MAIN Procedure
1512: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TMPL_SET
1513: IF(L_DEBUG_ENABLED='Y') THEN

Line 1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1532: END;
1533: END IF;
1534: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TMPL_SET
1535: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;
1540: EXCEPTION

Line 1538: RAISE FND_API.G_EXC_ERROR;

1534: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TMPL_SET
1535: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO COPY_TMPL_SET2;

Line 1541: WHEN FND_API.G_EXC_ERROR THEN

1537: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1538: RAISE FND_API.G_EXC_ERROR;
1539: END IF;
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO COPY_TMPL_SET2;
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1545: ,p_count => x_msg_count

Line 1543: x_return_status := FND_API.G_RET_STS_ERROR;

1539: END IF;
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO COPY_TMPL_SET2;
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO COPY_TMPL_SET2;
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1551: ,p_count => x_msg_count

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1545: ,p_count => x_msg_count
1546: ,p_data => x_msg_data);
1547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1548: ROLLBACK TO COPY_TMPL_SET2;
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1551: ,p_count => x_msg_count
1552: ,p_data => x_msg_data);
1553: WHEN OTHERS THEN

Line 1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1555: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TMPL_SET');
1556: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1557: ,p_count => x_msg_count
1558: ,p_data => x_msg_data);
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: END COPY_TMPL_SET;
1561:
1562:
1563: PROCEDURE COPY_TEMPLATE(p_api_version IN NUMBER,

Line 1579: x_return_status := FND_API.G_RET_STS_SUCCESS;

1575: l_source_tmpl_id NUMBER := p_source_tmpl_id;
1576: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1577: BEGIN
1578: SAVEPOINT COPY_TEMPLATE2;
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580: -- customer pre-processing
1581: -- Run the MAIN Procedure
1582: -- Start of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TEMPLATE
1583: IF(L_DEBUG_ENABLED='Y') THEN

Line 1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1603: END;
1604: END IF;
1605: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TEMPLATE
1606: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611: EXCEPTION

Line 1609: RAISE FND_API.G_EXC_ERROR;

1605: -- End of wraper code generated automatically by Debug code generator for OKL_PROCESS_TMPT_SET_PVT.COPY_TEMPLATE
1606: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: ROLLBACK TO COPY_TEMPLATE2;

Line 1612: WHEN FND_API.G_EXC_ERROR THEN

1608: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: ROLLBACK TO COPY_TEMPLATE2;
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1616: ,p_count => x_msg_count

Line 1614: x_return_status := FND_API.G_RET_STS_ERROR;

1610: END IF;
1611: EXCEPTION
1612: WHEN FND_API.G_EXC_ERROR THEN
1613: ROLLBACK TO COPY_TEMPLATE2;
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1616: ,p_count => x_msg_count
1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1616: ,p_count => x_msg_count
1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO COPY_TEMPLATE2;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1622: ,p_count => x_msg_count

Line 1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1616: ,p_count => x_msg_count
1617: ,p_data => x_msg_data);
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO COPY_TEMPLATE2;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1622: ,p_count => x_msg_count
1623: ,p_data => x_msg_data);
1624: WHEN OTHERS THEN

Line 1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1626: FND_MSG_PUB.ADD_EXC_MSG('OKL_COPY_TEMPLATE_PUB','COPY_TEMPLATE');
1627: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
1628: ,p_count => x_msg_count
1629: ,p_data => x_msg_data);
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: END COPY_TEMPLATE;
1632:
1633: END OKL_PROCESS_TMPT_SET_PUB;
1634: