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_adpv_rec := p_adpv_rec;
38: g_adpv_rec := l_adpv_rec;
39: -- Customer pre processing section
61: EXCEPTION
62: When FND_API.G_EXC_ERROR then
63: ROLLBACK TO create_txd_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_txd_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_txd_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_txd_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_txd_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_txd_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_txd_asset_Def;
72: When OTHERS then
73: ROLLBACK TO create_txd_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_txd_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_txd_asset_Def;
80:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO create_txd_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_txd_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_txd_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_txd_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_txd_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_txd_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_txd_asset_Def;
139: WHEN OTHERS then
140: ROLLBACK TO create_txd_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_txd_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_txd_asset_Def;
147: -- Start of comments
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176: -- Initialize message list if p_init_msg_list is set to TRUE.
177: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
178: FND_MSG_PUB.initialize;
179: END IF;
180: l_adpv_rec := p_adpv_rec;
181: g_adpv_rec := l_adpv_rec;
182: -- Customer pre processing section
204: EXCEPTION
205: When FND_API.G_EXC_ERROR then
206: ROLLBACK TO update_txd_asset_Def_pub;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
209: p_data => x_msg_data);
210: When FND_API.G_EXC_UNEXPECTED_ERROR then
211: ROLLBACK TO update_txd_asset_Def_pub;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: p_data => x_msg_data);
210: When FND_API.G_EXC_UNEXPECTED_ERROR then
211: ROLLBACK TO update_txd_asset_Def_pub;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
214: p_data => x_msg_data);
215: When OTHERS then
216: ROLLBACK TO update_txd_asset_Def_pub;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: p_data => x_msg_data);
215: When OTHERS then
216: ROLLBACK TO update_txd_asset_Def_pub;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222:
215: When OTHERS then
216: ROLLBACK TO update_txd_asset_Def_pub;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223: END update_txd_asset_Def;
268: EXCEPTION
269: When FND_API.G_EXC_ERROR then
270: ROLLBACK TO update_txd_asset_Def_pub;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
273: p_data => x_msg_data);
274: When FND_API.G_EXC_UNEXPECTED_ERROR then
275: ROLLBACK TO update_txd_asset_Def_pub;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: p_data => x_msg_data);
274: When FND_API.G_EXC_UNEXPECTED_ERROR then
275: ROLLBACK TO update_txd_asset_Def_pub;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
278: p_data => x_msg_data);
279: When OTHERS then
280: ROLLBACK TO update_txd_asset_Def_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278: p_data => x_msg_data);
279: When OTHERS then
280: ROLLBACK TO update_txd_asset_Def_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
283: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286: END update_txd_asset_Def;
279: When OTHERS then
280: ROLLBACK TO update_txd_asset_Def_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'update_txd_asset_Def_pub');
283: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286: END update_txd_asset_Def;
287:
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317: -- Initialize message list if p_init_msg_list is set to TRUE.
318: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
319: FND_MSG_PUB.initialize;
320: END IF;
321: l_adpv_rec := p_adpv_rec;
322: g_adpv_rec := l_adpv_rec;
323: -- Customer pre processing section
343: EXCEPTION
344: When FND_API.G_EXC_ERROR then
345: ROLLBACK TO delete_txd_asset_Def_pub;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
348: p_data => x_msg_data);
349: When FND_API.G_EXC_UNEXPECTED_ERROR then
350: ROLLBACK TO delete_txd_asset_Def_pub;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: p_data => x_msg_data);
349: When FND_API.G_EXC_UNEXPECTED_ERROR then
350: ROLLBACK TO delete_txd_asset_Def_pub;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
353: p_data => x_msg_data);
354: When OTHERS then
355: ROLLBACK TO delete_txd_asset_Def_pub;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: p_data => x_msg_data);
354: When OTHERS then
355: ROLLBACK TO delete_txd_asset_Def_pub;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
358: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
359: p_count => x_msg_count,
360: p_data => x_msg_data);
361: END delete_txd_asset_Def;
354: When OTHERS then
355: ROLLBACK TO delete_txd_asset_Def_pub;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
358: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
359: p_count => x_msg_count,
360: p_data => x_msg_data);
361: END delete_txd_asset_Def;
362:
404: EXCEPTION
405: When FND_API.G_EXC_ERROR then
406: ROLLBACK TO delete_txd_asset_Def_pub;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
409: p_data => x_msg_data);
410: When FND_API.G_EXC_UNEXPECTED_ERROR then
411: ROLLBACK TO delete_txd_asset_Def_pub;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: p_data => x_msg_data);
410: When FND_API.G_EXC_UNEXPECTED_ERROR then
411: ROLLBACK TO delete_txd_asset_Def_pub;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
414: p_data => x_msg_data);
415: When OTHERS then
416: ROLLBACK TO delete_txd_asset_Def_pub;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: p_data => x_msg_data);
415: When OTHERS then
416: ROLLBACK TO delete_txd_asset_Def_pub;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
419: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data);
422: END delete_txd_asset_Def;
415: When OTHERS then
416: ROLLBACK TO delete_txd_asset_Def_pub;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'delete_txd_asset_Def_pub');
419: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
420: p_count => x_msg_count,
421: p_data => x_msg_data);
422: END delete_txd_asset_Def;
423:
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452: -- Initialize message list if p_init_msg_list is set to TRUE.
453: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456: l_adpv_rec := p_adpv_rec;
457: -- Business API call section
458: l_adpv_rec.id := p_adpv_rec.id;
473: EXCEPTION
474: When FND_API.G_EXC_ERROR then
475: ROLLBACK TO lock_txd_asset_Def_pub;
476: x_return_status := FND_API.G_RET_STS_ERROR;
477: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
478: p_data => x_msg_data);
479: When FND_API.G_EXC_UNEXPECTED_ERROR then
480: ROLLBACK TO lock_txd_asset_Def_pub;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: p_data => x_msg_data);
479: When FND_API.G_EXC_UNEXPECTED_ERROR then
480: ROLLBACK TO lock_txd_asset_Def_pub;
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
483: p_data => x_msg_data);
484: When OTHERS then
485: ROLLBACK TO lock_txd_asset_Def_pub;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: p_data => x_msg_data);
484: When OTHERS then
485: ROLLBACK TO lock_txd_asset_Def_pub;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_txd_asset_Def_pub');
488: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
489: p_count => x_msg_count,
490: p_data => x_msg_data);
491: end lock_txd_asset_Def;
484: When OTHERS then
485: ROLLBACK TO lock_txd_asset_Def_pub;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_txd_asset_Def_pub');
488: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
489: p_count => x_msg_count,
490: p_data => x_msg_data);
491: end lock_txd_asset_Def;
492:
535: EXCEPTION
536: When FND_API.G_EXC_ERROR then
537: ROLLBACK TO lock_txd_asset_Def_pub;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
540: p_data => x_msg_data);
541: When FND_API.G_EXC_UNEXPECTED_ERROR then
542: ROLLBACK TO lock_txd_asset_Def_pub;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: p_data => x_msg_data);
541: When FND_API.G_EXC_UNEXPECTED_ERROR then
542: ROLLBACK TO lock_txd_asset_Def_pub;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
545: p_data => x_msg_data);
546: When OTHERS then
547: ROLLBACK TO lock_txd_asset_Def_pub;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: p_data => x_msg_data);
546: When OTHERS then
547: ROLLBACK TO lock_txd_asset_Def_pub;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_txd_asset_Def_pub');
550: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);
553: end lock_txd_asset_Def;
546: When OTHERS then
547: ROLLBACK TO lock_txd_asset_Def_pub;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'lock_txd_asset_Def_pub');
550: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
551: p_count => x_msg_count,
552: p_data => x_msg_data);
553: end lock_txd_asset_Def;
554:
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: END IF;
584: -- Initialize message list if p_init_msg_list is set to TRUE.
585: IF (FND_API.to_Boolean( p_init_msg_list )) THEN
586: FND_MSG_PUB.initialize;
587: END IF;
588: l_adpv_rec := p_adpv_rec;
589: g_adpv_rec := l_adpv_rec;
590: -- Customer pre processing section
610: EXCEPTION
611: When FND_API.G_EXC_ERROR then
612: ROLLBACK TO validate_txd_asset_Def_pub;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
615: p_data => x_msg_data);
616: When FND_API.G_EXC_UNEXPECTED_ERROR then
617: ROLLBACK TO validate_txd_asset_Def_pub;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: p_data => x_msg_data);
616: When FND_API.G_EXC_UNEXPECTED_ERROR then
617: ROLLBACK TO validate_txd_asset_Def_pub;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
620: p_data => x_msg_data);
621: When OTHERS then
622: ROLLBACK TO validate_txd_asset_Def_pub;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: p_data => x_msg_data);
621: When OTHERS then
622: ROLLBACK TO validate_txd_asset_Def_pub;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_txd_asset_Def_pub');
625: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data);
628: end validate_txd_asset_Def;
621: When OTHERS then
622: ROLLBACK TO validate_txd_asset_Def_pub;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_txd_asset_Def_pub');
625: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
626: p_count => x_msg_count,
627: p_data => x_msg_data);
628: end validate_txd_asset_Def;
629:
672: EXCEPTION
673: When FND_API.G_EXC_ERROR then
674: ROLLBACK TO validate_txd_asset_Def_pub;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
677: p_data => x_msg_data);
678: When FND_API.G_EXC_UNEXPECTED_ERROR then
679: ROLLBACK TO validate_txd_asset_Def_pub;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
677: p_data => x_msg_data);
678: When FND_API.G_EXC_UNEXPECTED_ERROR then
679: ROLLBACK TO validate_txd_asset_Def_pub;
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
681: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
682: p_data => x_msg_data);
683: When OTHERS then
684: ROLLBACK TO validate_txd_asset_Def_pub;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: p_data => x_msg_data);
683: When OTHERS then
684: ROLLBACK TO validate_txd_asset_Def_pub;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_txd_asset_Def_pub');
687: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data);
690: end validate_txd_asset_Def;
683: When OTHERS then
684: ROLLBACK TO validate_txd_asset_Def_pub;
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: FND_MSG_PUB.ADD_EXC_MSG( G_PKG_NAME, 'validate_txd_asset_Def_pub');
687: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
688: p_count => x_msg_count,
689: p_data => x_msg_data);
690: end validate_txd_asset_Def;
691: