31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37: l_tlpv_rec := p_tlpv_rec;
38: g_tlpv_rec := l_tlpv_rec;
39: -- Customer pre processing section
61: EXCEPTION
62: When FND_API.G_EXC_ERROR then
63: ROLLBACK TO create_txl_asset_Def_pub;
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
66: p_data => x_msg_data);
67: When FND_API.G_EXC_UNEXPECTED_ERROR then
68: ROLLBACK TO create_txl_asset_Def_pub;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: p_data => x_msg_data);
67: When FND_API.G_EXC_UNEXPECTED_ERROR then
68: ROLLBACK TO create_txl_asset_Def_pub;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
71: p_data => x_msg_data);
72: When OTHERS then
73: ROLLBACK TO create_txl_asset_Def_pub;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
71: p_data => x_msg_data);
72: When OTHERS then
73: ROLLBACK TO create_txl_asset_Def_pub;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_txl_asset_Def_pub');
76: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
77: p_count => x_msg_count,
78: p_data => x_msg_data);
79: END create_txl_asset_Def;
72: When OTHERS then
73: ROLLBACK TO create_txl_asset_Def_pub;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'create_txl_asset_Def_pub');
76: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
77: p_count => x_msg_count,
78: p_data => x_msg_data);
79: END create_txl_asset_Def;
80:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO create_txl_asset_Def_pub;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
133: p_data => x_msg_data);
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO create_txl_asset_Def_pub;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: p_data => x_msg_data);
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO create_txl_asset_Def_pub;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
138: p_data => x_msg_data);
139: WHEN OTHERS then
140: ROLLBACK TO create_txl_asset_Def_pub;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: p_data => x_msg_data);
139: WHEN OTHERS then
140: ROLLBACK TO create_txl_asset_Def_pub;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_txl_asset_Def_pub');
143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146: END create_txl_asset_Def;
139: WHEN OTHERS then
140: ROLLBACK TO create_txl_asset_Def_pub;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'create_txl_asset_Def_pub');
143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data);
146: END create_txl_asset_Def;
147:
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177: -- Initialize message list if p_init_msg_list is set to TRUE.
178: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
179: FND_MSG_PUB.initialize;
180: END IF;
181: l_tlpv_rec := p_tlpv_rec;
182: g_tlpv_rec := l_tlpv_rec;
183: -- Customer pre processing section
205: EXCEPTION
206: When FND_API.G_EXC_ERROR then
207: ROLLBACK TO update_txl_asset_Def_pub;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
210: p_data => x_msg_data);
211: When FND_API.G_EXC_UNEXPECTED_ERROR then
212: ROLLBACK TO update_txl_asset_Def_pub;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: p_data => x_msg_data);
211: When FND_API.G_EXC_UNEXPECTED_ERROR then
212: ROLLBACK TO update_txl_asset_Def_pub;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
215: p_data => x_msg_data);
216: When OTHERS then
217: ROLLBACK TO update_txl_asset_Def_pub;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
215: p_data => x_msg_data);
216: When OTHERS then
217: ROLLBACK TO update_txl_asset_Def_pub;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txl_asset_Def_pub');
220: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
221: p_count => x_msg_count,
222: p_data => x_msg_data);
223: END update_txl_asset_Def;
216: When OTHERS then
217: ROLLBACK TO update_txl_asset_Def_pub;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txl_asset_Def_pub');
220: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
221: p_count => x_msg_count,
222: p_data => x_msg_data);
223: END update_txl_asset_Def;
224:
272: EXCEPTION
273: WHEN FND_API.G_EXC_ERROR THEN
274: ROLLBACK TO update_txl_asset_Def_pub;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
277: p_data => x_msg_data);
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO update_txl_asset_Def_pub;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: p_data => x_msg_data);
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO update_txl_asset_Def_pub;
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
282: p_data => x_msg_data);
283: WHEN OTHERS then
284: ROLLBACK TO update_txl_asset_Def_pub;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: p_data => x_msg_data);
283: WHEN OTHERS then
284: ROLLBACK TO update_txl_asset_Def_pub;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_txl_asset_Def_pub');
287: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
288: p_count => x_msg_count,
289: p_data => x_msg_data);
290: END update_txl_asset_Def;
283: WHEN OTHERS then
284: ROLLBACK TO update_txl_asset_Def_pub;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'update_txl_asset_Def_pub');
287: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
288: p_count => x_msg_count,
289: p_data => x_msg_data);
290: END update_txl_asset_Def;
291:
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321: -- Initialize message list if p_init_msg_list is set to TRUE.
322: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325: l_tlpv_rec := p_tlpv_rec;
326: g_tlpv_rec := l_tlpv_rec;
327: -- Customer pre processing section
347: EXCEPTION
348: When FND_API.G_EXC_ERROR then
349: ROLLBACK TO delete_txl_asset_Def_pub;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
352: p_data => x_msg_data);
353: When FND_API.G_EXC_UNEXPECTED_ERROR then
354: ROLLBACK TO delete_txl_asset_Def_pub;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: p_data => x_msg_data);
353: When FND_API.G_EXC_UNEXPECTED_ERROR then
354: ROLLBACK TO delete_txl_asset_Def_pub;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
357: p_data => x_msg_data);
358: When OTHERS then
359: ROLLBACK TO delete_txl_asset_Def_pub;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: p_data => x_msg_data);
358: When OTHERS then
359: ROLLBACK TO delete_txl_asset_Def_pub;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txl_asset_Def_pub');
362: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365: END delete_txl_asset_Def;
358: When OTHERS then
359: ROLLBACK TO delete_txl_asset_Def_pub;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txl_asset_Def_pub');
362: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365: END delete_txl_asset_Def;
366:
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: ROLLBACK TO delete_txl_asset_Def_pub;
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
417: p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO delete_txl_asset_Def_pub;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: p_data => x_msg_data);
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: ROLLBACK TO delete_txl_asset_Def_pub;
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
422: p_data => x_msg_data);
423: WHEN OTHERS then
424: ROLLBACK TO delete_txl_asset_Def_pub;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: p_data => x_msg_data);
423: WHEN OTHERS then
424: ROLLBACK TO delete_txl_asset_Def_pub;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_txl_asset_Def_pub');
427: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430: END delete_txl_asset_Def;
423: WHEN OTHERS then
424: ROLLBACK TO delete_txl_asset_Def_pub;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'delete_txl_asset_Def_pub');
427: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430: END delete_txl_asset_Def;
431:
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461: -- Initialize message list if p_init_msg_list is set to TRUE.
462: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: l_tlpv_rec := p_tlpv_rec;
466: g_tlpv_rec := l_tlpv_rec;
467: -- Customer pre processing section
487: EXCEPTION
488: When FND_API.G_EXC_ERROR then
489: ROLLBACK TO validate_txl_asset_Def_pub;
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
492: p_data => x_msg_data);
493: When FND_API.G_EXC_UNEXPECTED_ERROR then
494: ROLLBACK TO validate_txl_asset_Def_pub;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: p_data => x_msg_data);
493: When FND_API.G_EXC_UNEXPECTED_ERROR then
494: ROLLBACK TO validate_txl_asset_Def_pub;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
497: p_data => x_msg_data);
498: When OTHERS then
499: ROLLBACK TO validate_txl_asset_Def_pub;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: p_data => x_msg_data);
498: When OTHERS then
499: ROLLBACK TO validate_txl_asset_Def_pub;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_txl_asset_Def_pub');
502: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data);
505: END validate_txl_asset_Def;
498: When OTHERS then
499: ROLLBACK TO validate_txl_asset_Def_pub;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_txl_asset_Def_pub');
502: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data);
505: END validate_txl_asset_Def;
506:
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO validate_txl_asset_Def_pub;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
557: p_data => x_msg_data);
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO validate_txl_asset_Def_pub;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: p_data => x_msg_data);
558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
559: ROLLBACK TO validate_txl_asset_Def_pub;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563: WHEN OTHERS then
564: ROLLBACK TO validate_txl_asset_Def_pub;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562: p_data => x_msg_data);
563: WHEN OTHERS then
564: ROLLBACK TO validate_txl_asset_Def_pub;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_txl_asset_Def_pub');
567: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570: END validate_txl_asset_Def;
563: WHEN OTHERS then
564: ROLLBACK TO validate_txl_asset_Def_pub;
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'validate_txl_asset_Def_pub');
567: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570: END validate_txl_asset_Def;
571:
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605: -- Business API call section
606: l_tlpv_rec.id := p_tlpv_rec.id;
607: l_tlpv_rec.object_version_number := p_tlpv_rec.object_version_number;
621: EXCEPTION
622: When FND_API.G_EXC_ERROR then
623: ROLLBACK TO lock_txl_ass_pub;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
626: p_data => x_msg_data);
627: When FND_API.G_EXC_UNEXPECTED_ERROR then
628: ROLLBACK TO lock_txl_ass_pub;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: p_data => x_msg_data);
627: When FND_API.G_EXC_UNEXPECTED_ERROR then
628: ROLLBACK TO lock_txl_ass_pub;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
631: p_data => x_msg_data);
632: When OTHERS then
633: ROLLBACK TO lock_txl_ass_pub;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: p_data => x_msg_data);
632: When OTHERS then
633: ROLLBACK TO lock_txl_ass_pub;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_txl_asset_Def_pub');
636: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data);
639: END lock_txl_asset_Def;
632: When OTHERS then
633: ROLLBACK TO lock_txl_ass_pub;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_txl_asset_Def_pub');
636: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data);
639: END lock_txl_asset_Def;
640:
686: EXCEPTION
687: WHEN FND_API.G_EXC_ERROR THEN
688: ROLLBACK TO lock_txl_ass_pub;
689: x_return_status := FND_API.G_RET_STS_ERROR;
690: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
691: p_data => x_msg_data);
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: ROLLBACK TO lock_txl_ass_pub;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: p_data => x_msg_data);
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: ROLLBACK TO lock_txl_ass_pub;
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
696: p_data => x_msg_data);
697: WHEN OTHERS then
698: ROLLBACK TO lock_txl_ass_pub;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: p_data => x_msg_data);
697: WHEN OTHERS then
698: ROLLBACK TO lock_txl_ass_pub;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_txl_asset_Def_pub');
701: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data);
704: END lock_txl_asset_Def;
697: WHEN OTHERS then
698: ROLLBACK TO lock_txl_ass_pub;
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'lock_txl_asset_Def_pub');
701: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data);
704: END lock_txl_asset_Def;
705: