APPS.OKL_TXD_ASSETS_PUB dependencies on FND_API

Line 21: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

17: p_adpv_rec IN adpv_rec_type,
18: x_adpv_rec OUT NOCOPY adpv_rec_type) IS
19:
20: l_adpv_rec adpv_rec_type;
21: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
22: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXD_ASSET_DEF';
23: l_api_version CONSTANT NUMBER := 1;
24: BEGIN
25: savepoint create_txd_asset_Def_pub;

Line 27: IF NOT (FND_API.Compatible_API_Call (l_api_version,

23: l_api_version CONSTANT NUMBER := 1;
24: BEGIN
25: savepoint create_txd_asset_Def_pub;
26: -- Standard call to check for call compatibility.
27: IF NOT (FND_API.Compatible_API_Call (l_api_version,
28: p_api_version,
29: l_api_name,
30: G_PKG_NAME)) THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

27: IF NOT (FND_API.Compatible_API_Call (l_api_version,
28: p_api_version,
29: l_api_name,
30: G_PKG_NAME)) THEN
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;

Line 34: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

30: G_PKG_NAME)) THEN
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;

Line 51: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

47: x_msg_count => x_msg_count,
48: x_msg_data => x_msg_data,
49: p_asdv_rec => l_adpv_rec,
50: x_asdv_rec => x_adpv_rec);
51: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;

Line 52: RAISE FND_API.G_EXC_ERROR;

48: x_msg_data => x_msg_data,
49: p_asdv_rec => l_adpv_rec,
50: x_asdv_rec => x_adpv_rec);
51: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56: l_adpv_rec := x_adpv_rec;

Line 53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

49: p_asdv_rec => l_adpv_rec,
50: x_asdv_rec => x_adpv_rec);
51: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56: l_adpv_rec := x_adpv_rec;
57: g_adpv_rec := l_adpv_rec;

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: x_asdv_rec => x_adpv_rec);
51: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
52: RAISE FND_API.G_EXC_ERROR;
53: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56: l_adpv_rec := x_adpv_rec;
57: g_adpv_rec := l_adpv_rec;
58: -- Verticle industry post- processing section

Line 60: x_return_status := FND_API.G_RET_STS_SUCCESS;

56: l_adpv_rec := x_adpv_rec;
57: g_adpv_rec := l_adpv_rec;
58: -- Verticle industry post- processing section
59: -- Customer post processing section
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 62: When FND_API.G_EXC_ERROR then

58: -- Verticle industry post- processing section
59: -- Customer post processing section
60: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 64: x_return_status := FND_API.G_RET_STS_ERROR;

60: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 67: When FND_API.G_EXC_UNEXPECTED_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;
70: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
71: p_data => x_msg_data);

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 74: 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;
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);

Line 76: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 99: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_adpv_tbl IN adpv_tbl_type,
97: x_adpv_tbl OUT NOCOPY adpv_tbl_type) IS
98: i NUMBER := 0;
99: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
100: BEGIN
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102: IF p_adpv_tbl.COUNT > 0 THEN
103: i := p_adpv_tbl.FIRST;

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: x_adpv_tbl OUT NOCOPY adpv_tbl_type) IS
98: i NUMBER := 0;
99: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
100: BEGIN
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102: IF p_adpv_tbl.COUNT > 0 THEN
103: i := p_adpv_tbl.FIRST;
104: LOOP
105: create_txd_asset_Def(p_api_version => p_api_version,

Line 112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

108: x_msg_count => x_msg_count,
109: x_msg_data => x_msg_data,
110: p_adpv_rec => p_adpv_tbl(i),
111: x_adpv_rec => x_adpv_tbl(i));
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
114: x_return_status := l_return_status;
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 113: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

109: x_msg_data => x_msg_data,
110: p_adpv_rec => p_adpv_tbl(i),
111: x_adpv_rec => x_adpv_tbl(i));
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
114: x_return_status := l_return_status;
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
117: x_return_status := l_return_status;

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: x_adpv_rec => x_adpv_tbl(i));
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
114: x_return_status := l_return_status;
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
117: x_return_status := l_return_status;
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE

Line 116: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
114: x_return_status := l_return_status;
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
117: x_return_status := l_return_status;
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE
120: x_return_status := l_return_status;

Line 118: RAISE FND_API.G_EXC_ERROR;

114: x_return_status := l_return_status;
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
117: x_return_status := l_return_status;
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE
120: x_return_status := l_return_status;
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117: x_return_status := l_return_status;
118: RAISE FND_API.G_EXC_ERROR;
119: ELSE
120: x_return_status := l_return_status;
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123: END IF;
124: EXIT WHEN (i = p_adpv_tbl.LAST);
125: i := p_adpv_tbl.NEXT(i);

Line 129: WHEN FND_API.G_EXC_ERROR THEN

125: i := p_adpv_tbl.NEXT(i);
126: END LOOP;
127: END IF;
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);

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: END IF;
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;

Line 134: WHEN FND_API.G_EXC_UNEXPECTED_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;
137: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
138: p_data => x_msg_data);

Line 136: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 141: 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;
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);

Line 143: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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

Line 170: IF NOT (FND_API.Compatible_API_Call (l_api_version,

166: l_api_version CONSTANT NUMBER := 1;
167: BEGIN
168: savepoint update_txd_asset_Def_pub;
169: -- Standard call to check for call compatibility.
170: IF NOT (FND_API.Compatible_API_Call (l_api_version,
171: p_api_version,
172: l_api_name,
173: G_PKG_NAME)) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170: IF NOT (FND_API.Compatible_API_Call (l_api_version,
171: p_api_version,
172: l_api_name,
173: G_PKG_NAME)) THEN
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;

Line 177: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

173: G_PKG_NAME)) THEN
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;

Line 194: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

190: x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data,
192: p_asdv_rec => l_adpv_rec,
193: x_asdv_rec => x_adpv_rec);
194: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;

Line 195: RAISE FND_API.G_EXC_ERROR;

191: x_msg_data => x_msg_data,
192: p_asdv_rec => l_adpv_rec,
193: x_asdv_rec => x_adpv_rec);
194: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199: l_adpv_rec := x_adpv_rec;

Line 196: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

192: p_asdv_rec => l_adpv_rec,
193: x_asdv_rec => x_adpv_rec);
194: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199: l_adpv_rec := x_adpv_rec;
200: g_adpv_rec := l_adpv_rec;

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: x_asdv_rec => x_adpv_rec);
194: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199: l_adpv_rec := x_adpv_rec;
200: g_adpv_rec := l_adpv_rec;
201: -- Verticle industry post- processing section

Line 203: x_return_status := FND_API.G_RET_STS_SUCCESS;

199: l_adpv_rec := x_adpv_rec;
200: g_adpv_rec := l_adpv_rec;
201: -- Verticle industry post- processing section
202: -- Customer post processing section
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 205: When FND_API.G_EXC_ERROR then

201: -- Verticle industry post- processing section
202: -- Customer post processing section
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 210: When FND_API.G_EXC_UNEXPECTED_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;
213: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
214: p_data => x_msg_data);

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 217: 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;
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);

Line 219: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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;

Line 256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

252: x_msg_count => x_msg_count,
253: x_msg_data => x_msg_data,
254: p_adpv_rec => p_adpv_tbl(i),
255: x_adpv_rec => x_adpv_tbl(i));
256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
257: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
258: x_return_status := l_return_status;
259: raise G_EXCEPTION_HALT_VALIDATION;
260: ELSE

Line 257: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

253: x_msg_data => x_msg_data,
254: p_adpv_rec => p_adpv_tbl(i),
255: x_adpv_rec => x_adpv_tbl(i));
256: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
257: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
258: x_return_status := l_return_status;
259: raise G_EXCEPTION_HALT_VALIDATION;
260: ELSE
261: x_return_status := l_return_status;

Line 269: When FND_API.G_EXC_ERROR then

265: i := p_adpv_tbl.NEXT(i);
266: END LOOP;
267: END IF;
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);

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: END IF;
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;

Line 274: When FND_API.G_EXC_UNEXPECTED_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;
277: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
278: p_data => x_msg_data);

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 281: 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;
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);

Line 283: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 311: IF NOT (FND_API.Compatible_API_Call (l_api_version,

307: l_api_version CONSTANT NUMBER := 1;
308: BEGIN
309: savepoint delete_txd_asset_Def_pub;
310: -- Standard call to check for call compatibility.
311: IF NOT (FND_API.Compatible_API_Call (l_api_version,
312: p_api_version,
313: l_api_name,
314: G_PKG_NAME)) THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311: IF NOT (FND_API.Compatible_API_Call (l_api_version,
312: p_api_version,
313: l_api_name,
314: G_PKG_NAME)) THEN
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;

Line 318: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

314: G_PKG_NAME)) THEN
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;

Line 334: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

330: x_return_status => l_return_status,
331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,
333: p_asdv_rec => l_adpv_rec);
334: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
335: RAISE FND_API.G_EXC_ERROR;
336: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;

Line 335: RAISE FND_API.G_EXC_ERROR;

331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,
333: p_asdv_rec => l_adpv_rec);
334: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
335: RAISE FND_API.G_EXC_ERROR;
336: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: g_adpv_rec := l_adpv_rec;

Line 336: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

332: x_msg_data => x_msg_data,
333: p_asdv_rec => l_adpv_rec);
334: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
335: RAISE FND_API.G_EXC_ERROR;
336: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: g_adpv_rec := l_adpv_rec;
340: -- Verticle industry post- processing section

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: p_asdv_rec => l_adpv_rec);
334: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
335: RAISE FND_API.G_EXC_ERROR;
336: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: g_adpv_rec := l_adpv_rec;
340: -- Verticle industry post- processing section
341: -- Customer post processing section

Line 342: x_return_status := FND_API.G_RET_STS_SUCCESS;

338: END IF;
339: g_adpv_rec := l_adpv_rec;
340: -- Verticle industry post- processing section
341: -- Customer post processing section
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 344: When FND_API.G_EXC_ERROR then

340: -- Verticle industry post- processing section
341: -- Customer post processing section
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 346: x_return_status := FND_API.G_RET_STS_ERROR;

342: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 349: When FND_API.G_EXC_UNEXPECTED_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;
352: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
353: p_data => x_msg_data);

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 356: 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;
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);

Line 358: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 405: When FND_API.G_EXC_ERROR then

401: i := p_adpv_tbl.NEXT(i);
402: END LOOP;
403: END IF;
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);

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: END IF;
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;

Line 410: When FND_API.G_EXC_UNEXPECTED_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;
413: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
414: p_data => x_msg_data);

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 417: 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;
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);

Line 419: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 446: IF NOT (FND_API.Compatible_API_Call (l_api_version,

442: l_api_version CONSTANT NUMBER := 1;
443: BEGIN
444: savepoint lock_txd_asset_Def_pub;
445: -- Standard call to check for call compatibility.
446: IF NOT (FND_API.Compatible_API_Call (l_api_version,
447: p_api_version,
448: l_api_name,
449: G_PKG_NAME)) THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

446: IF NOT (FND_API.Compatible_API_Call (l_api_version,
447: p_api_version,
448: l_api_name,
449: G_PKG_NAME)) THEN
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;

Line 453: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

449: G_PKG_NAME)) THEN
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

Line 466: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

462: x_return_status => l_return_status,
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_asdv_rec => l_adpv_rec);
466: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;

Line 467: RAISE FND_API.G_EXC_ERROR;

463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_asdv_rec => l_adpv_rec);
466: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: g_adpv_rec := l_adpv_rec;

Line 468: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

464: x_msg_data => x_msg_data,
465: p_asdv_rec => l_adpv_rec);
466: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: g_adpv_rec := l_adpv_rec;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

465: p_asdv_rec => l_adpv_rec);
466: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
467: RAISE FND_API.G_EXC_ERROR;
468: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: g_adpv_rec := l_adpv_rec;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473: EXCEPTION

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470: END IF;
471: g_adpv_rec := l_adpv_rec;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 474: When FND_API.G_EXC_ERROR then

470: END IF;
471: g_adpv_rec := l_adpv_rec;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 476: x_return_status := FND_API.G_RET_STS_ERROR;

472: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 479: When FND_API.G_EXC_UNEXPECTED_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;
482: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
483: p_data => x_msg_data);

Line 481: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 486: 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;
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);

Line 488: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 536: When FND_API.G_EXC_ERROR then

532: i := p_adpv_tbl.NEXT(i);
533: END LOOP;
534: END IF;
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);

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: END IF;
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;

Line 541: When FND_API.G_EXC_UNEXPECTED_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;
544: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
545: p_data => x_msg_data);

Line 543: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 548: 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;
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);

Line 550: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 578: IF NOT (FND_API.Compatible_API_Call (l_api_version,

574: l_api_version CONSTANT NUMBER := 1;
575: BEGIN
576: savepoint validate_txd_asset_Def_pub;
577: -- Standard call to check for call compatibility.
578: IF NOT (FND_API.Compatible_API_Call (l_api_version,
579: p_api_version,
580: l_api_name,
581: G_PKG_NAME)) THEN
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

578: IF NOT (FND_API.Compatible_API_Call (l_api_version,
579: p_api_version,
580: l_api_name,
581: G_PKG_NAME)) THEN
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;

Line 585: IF (FND_API.to_Boolean( p_init_msg_list )) THEN

581: G_PKG_NAME)) THEN
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;

Line 601: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

597: x_return_status => l_return_status,
598: x_msg_count => x_msg_count,
599: x_msg_data => x_msg_data,
600: p_asdv_rec => l_adpv_rec);
601: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END IF;

Line 602: RAISE FND_API.G_EXC_ERROR;

598: x_msg_count => x_msg_count,
599: x_msg_data => x_msg_data,
600: p_asdv_rec => l_adpv_rec);
601: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END IF;
606: g_adpv_rec := l_adpv_rec;

Line 603: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

599: x_msg_data => x_msg_data,
600: p_asdv_rec => l_adpv_rec);
601: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END IF;
606: g_adpv_rec := l_adpv_rec;
607: -- Verticle industry post- processing section

Line 604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

600: p_asdv_rec => l_adpv_rec);
601: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
602: RAISE FND_API.G_EXC_ERROR;
603: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: END IF;
606: g_adpv_rec := l_adpv_rec;
607: -- Verticle industry post- processing section
608: -- Customer post processing section

Line 609: x_return_status := FND_API.G_RET_STS_SUCCESS;

605: END IF;
606: g_adpv_rec := l_adpv_rec;
607: -- Verticle industry post- processing section
608: -- Customer post processing section
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 611: When FND_API.G_EXC_ERROR then

607: -- Verticle industry post- processing section
608: -- Customer post processing section
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
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);

Line 613: x_return_status := FND_API.G_RET_STS_ERROR;

609: x_return_status := FND_API.G_RET_STS_SUCCESS;
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;

Line 616: When FND_API.G_EXC_UNEXPECTED_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;
619: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
620: p_data => x_msg_data);

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 623: 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;
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);

Line 625: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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:

Line 673: When FND_API.G_EXC_ERROR then

669: i := p_adpv_tbl.NEXT(i);
670: END LOOP;
671: END IF;
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);

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: END IF;
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;

Line 678: When FND_API.G_EXC_UNEXPECTED_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;
681: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
682: p_data => x_msg_data);

Line 680: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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;

Line 685: 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;
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);

Line 687: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

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: