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.AMS_DELIVKITITEM_PUB dependencies on FND_API

Line 24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

20:
21: PROCEDURE Create_DelivKitItem(
22:
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25: p_commit IN VARCHAR2 := FND_API.g_false,
26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27:
28: x_return_status OUT NOCOPY VARCHAR2,

Line 25: p_commit IN VARCHAR2 := FND_API.g_false,

21: PROCEDURE Create_DelivKitItem(
22:
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25: p_commit IN VARCHAR2 := FND_API.g_false,
26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,

Line 26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

22:
23: p_api_version_number IN NUMBER,
24: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
25: p_commit IN VARCHAR2 := FND_API.g_false,
26: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,

Line 51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

47:
48: SAVEPOINT CREATE_DelivKitItem_PUB;
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )

Line 60: IF FND_API.to_Boolean( p_init_msg_list )

56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
67:
68:
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: --
73: -- API body
74: --

Line 86: IF l_return_status = FND_API.g_ret_sts_error THEN

82: l_pvt_DelivKitItem_rec,
83: l_return_status
84: );
85:
86: IF l_return_status = FND_API.g_ret_sts_error THEN
87: RAISE FND_API.g_exc_error;
88: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;

Line 87: RAISE FND_API.g_exc_error;

83: l_return_status
84: );
85:
86: IF l_return_status = FND_API.g_ret_sts_error THEN
87: RAISE FND_API.g_exc_error;
88: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: END IF;

Line 88: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

84: );
85:
86: IF l_return_status = FND_API.g_ret_sts_error THEN
87: RAISE FND_API.g_exc_error;
88: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: END IF;
92:

Line 89: RAISE FND_API.g_exc_unexpected_error;

85:
86: IF l_return_status = FND_API.g_ret_sts_error THEN
87: RAISE FND_API.g_exc_error;
88: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
89: RAISE FND_API.g_exc_unexpected_error;
90: END IF;
91: END IF;
92:
93: -- vertical industry pre-processing

Line 101: IF l_return_status = FND_API.g_ret_sts_error THEN

97: l_pvt_DelivKitItem_rec,
98: l_return_status
99: );
100:
101: IF l_return_status = FND_API.g_ret_sts_error THEN
102: RAISE FND_API.g_exc_error;
103: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
104: RAISE FND_API.g_exc_unexpected_error;
105: END IF;

Line 102: RAISE FND_API.g_exc_error;

98: l_return_status
99: );
100:
101: IF l_return_status = FND_API.g_ret_sts_error THEN
102: RAISE FND_API.g_exc_error;
103: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
104: RAISE FND_API.g_exc_unexpected_error;
105: END IF;
106: END IF;

Line 103: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

99: );
100:
101: IF l_return_status = FND_API.g_ret_sts_error THEN
102: RAISE FND_API.g_exc_error;
103: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
104: RAISE FND_API.g_exc_unexpected_error;
105: END IF;
106: END IF;
107: -------------------------------------------------------

Line 104: RAISE FND_API.g_exc_unexpected_error;

100:
101: IF l_return_status = FND_API.g_ret_sts_error THEN
102: RAISE FND_API.g_exc_error;
103: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
104: RAISE FND_API.g_exc_unexpected_error;
105: END IF;
106: END IF;
107: -------------------------------------------------------
108: AMS_DelivKitItem_PVT.Create_Deliv_Kit_Item(

Line 110: p_init_msg_list => FND_API.G_FALSE,

106: END IF;
107: -------------------------------------------------------
108: AMS_DelivKitItem_PVT.Create_Deliv_Kit_Item(
109: p_api_version => 1.0,
110: p_init_msg_list => FND_API.G_FALSE,
111: p_commit => FND_API.G_FALSE,
112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
113: x_return_status => x_return_status,
114: x_msg_count => x_msg_count,

Line 111: p_commit => FND_API.G_FALSE,

107: -------------------------------------------------------
108: AMS_DelivKitItem_PVT.Create_Deliv_Kit_Item(
109: p_api_version => 1.0,
110: p_init_msg_list => FND_API.G_FALSE,
111: p_commit => FND_API.G_FALSE,
112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
113: x_return_status => x_return_status,
114: x_msg_count => x_msg_count,
115: x_msg_data => x_msg_data,

Line 112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

108: AMS_DelivKitItem_PVT.Create_Deliv_Kit_Item(
109: p_api_version => 1.0,
110: p_init_msg_list => FND_API.G_FALSE,
111: p_commit => FND_API.G_FALSE,
112: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
113: x_return_status => x_return_status,
114: x_msg_count => x_msg_count,
115: x_msg_data => x_msg_data,
116: p_Deliv_Kit_Item_rec => l_pvt_DelivKitItem_rec,

Line 121: IF x_return_status = FND_API.G_RET_STS_ERROR then

117: x_Deliv_kit_item_id => x_Deliv_kit_item_id);
118:
119:
120: -- Check return status from the above procedure call
121: IF x_return_status = FND_API.G_RET_STS_ERROR then
122: RAISE FND_API.G_EXC_ERROR;
123: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;

Line 122: RAISE FND_API.G_EXC_ERROR;

118:
119:
120: -- Check return status from the above procedure call
121: IF x_return_status = FND_API.G_RET_STS_ERROR then
122: RAISE FND_API.G_EXC_ERROR;
123: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: --

Line 123: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

119:
120: -- Check return status from the above procedure call
121: IF x_return_status = FND_API.G_RET_STS_ERROR then
122: RAISE FND_API.G_EXC_ERROR;
123: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: --
127: -- End of API body.

Line 124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

120: -- Check return status from the above procedure call
121: IF x_return_status = FND_API.G_RET_STS_ERROR then
122: RAISE FND_API.G_EXC_ERROR;
123: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
125: END IF;
126: --
127: -- End of API body.
128: --

Line 139: IF l_return_status = FND_API.g_ret_sts_error THEN

135: x_Deliv_kit_item_id,
136: l_return_status
137: );
138:
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;

Line 140: RAISE FND_API.g_exc_error;

136: l_return_status
137: );
138:
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;
144: END IF;

Line 141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

137: );
138:
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;
144: END IF;
145:

Line 142: RAISE FND_API.g_exc_unexpected_error;

138:
139: IF l_return_status = FND_API.g_ret_sts_error THEN
140: RAISE FND_API.g_exc_error;
141: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
142: RAISE FND_API.g_exc_unexpected_error;
143: END IF;
144: END IF;
145:
146:

Line 157: IF l_return_status = FND_API.g_ret_sts_error THEN

153: x_Deliv_kit_item_id,
154: l_return_status
155: );
156:
157: IF l_return_status = FND_API.g_ret_sts_error THEN
158: RAISE FND_API.g_exc_error;
159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;

Line 158: RAISE FND_API.g_exc_error;

154: l_return_status
155: );
156:
157: IF l_return_status = FND_API.g_ret_sts_error THEN
158: RAISE FND_API.g_exc_error;
159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: END IF;

Line 159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

155: );
156:
157: IF l_return_status = FND_API.g_ret_sts_error THEN
158: RAISE FND_API.g_exc_error;
159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: END IF;
163: ------------------------------------------

Line 160: RAISE FND_API.g_exc_unexpected_error;

156:
157: IF l_return_status = FND_API.g_ret_sts_error THEN
158: RAISE FND_API.g_exc_error;
159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162: END IF;
163: ------------------------------------------
164:

Line 166: IF FND_API.to_Boolean( p_commit )

162: END IF;
163: ------------------------------------------
164:
165: -- Standard check for p_commit
166: IF FND_API.to_Boolean( p_commit )
167: THEN
168: COMMIT WORK;
169: END IF;
170:

Line 184: x_return_status := FND_API.g_ret_sts_error;

180:
181: EXCEPTION
182:
183: WHEN AMS_Utility_PVT.resource_locked THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
186: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
187: FND_MSG_PUB.add;
188: END IF;

Line 190: WHEN FND_API.G_EXC_ERROR THEN

186: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
187: FND_MSG_PUB.add;
188: END IF;
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO CREATE_DelivKitItem_PUB;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: END IF;
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO CREATE_DelivKitItem_PUB;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (
195: p_encoded => FND_API.G_FALSE,
196: p_count => x_msg_count,

Line 195: p_encoded => FND_API.G_FALSE,

191: ROLLBACK TO CREATE_DelivKitItem_PUB;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: -- Standard call to get message count and if count=1, get the message
194: FND_MSG_PUB.Count_And_Get (
195: p_encoded => FND_API.G_FALSE,
196: p_count => x_msg_count,
197: p_data => x_msg_data
198: );
199:

Line 200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

196: p_count => x_msg_count,
197: p_data => x_msg_data
198: );
199:
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO CREATE_DelivKitItem_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: );
199:
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO CREATE_DelivKitItem_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,

Line 205: p_encoded => FND_API.G_FALSE,

201: ROLLBACK TO CREATE_DelivKitItem_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209:

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: );
209:
210: WHEN OTHERS THEN
211: ROLLBACK TO CREATE_DelivKitItem_PUB;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;

Line 219: p_encoded => FND_API.G_FALSE,

215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );
223: End Create_DelivKitItem;

Line 228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

224:
225:
226: PROCEDURE Update_DelivKitItem(
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,

Line 229: p_commit IN VARCHAR2 := FND_API.G_FALSE,

225:
226: PROCEDURE Update_DelivKitItem(
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,

Line 230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

226: PROCEDURE Update_DelivKitItem(
227: p_api_version_number IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
234: p_Deliv_Kit_Item_rec IN AMS_DelivKitItem_PVT.deliv_kit_item_rec_type

Line 251: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

247: -- Standard Start of API savepoint
248: SAVEPOINT UPDATE_DelivKitItem_PUB;
249:
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
252: p_api_version_number,
253: l_api_name,
254: G_PKG_NAME)
255: THEN

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: p_api_version_number,
253: l_api_name,
254: G_PKG_NAME)
255: THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( p_init_msg_list )

Line 260: IF FND_API.to_Boolean( p_init_msg_list )

256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( p_init_msg_list )
261: THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
267:
268:
269: -- Initialize API return status to SUCCESS
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: -- customer pre-processing
273: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
274: THEN

Line 280: IF l_return_status = FND_API.g_ret_sts_error THEN

276: l_pvt_DelivKitItem_rec,
277: l_return_status
278: );
279:
280: IF l_return_status = FND_API.g_ret_sts_error THEN
281: RAISE FND_API.g_exc_error;
282: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: END IF;

Line 281: RAISE FND_API.g_exc_error;

277: l_return_status
278: );
279:
280: IF l_return_status = FND_API.g_ret_sts_error THEN
281: RAISE FND_API.g_exc_error;
282: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: END IF;
285: END IF;

Line 282: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

278: );
279:
280: IF l_return_status = FND_API.g_ret_sts_error THEN
281: RAISE FND_API.g_exc_error;
282: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: END IF;
285: END IF;
286:

Line 283: RAISE FND_API.g_exc_unexpected_error;

279:
280: IF l_return_status = FND_API.g_ret_sts_error THEN
281: RAISE FND_API.g_exc_error;
282: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
283: RAISE FND_API.g_exc_unexpected_error;
284: END IF;
285: END IF;
286:
287: -- vertical industry pre-processing

Line 295: IF l_return_status = FND_API.g_ret_sts_error THEN

291: l_pvt_DelivKitItem_rec,
292: l_return_status
293: );
294:
295: IF l_return_status = FND_API.g_ret_sts_error THEN
296: RAISE FND_API.g_exc_error;
297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
298: RAISE FND_API.g_exc_unexpected_error;
299: END IF;

Line 296: RAISE FND_API.g_exc_error;

292: l_return_status
293: );
294:
295: IF l_return_status = FND_API.g_ret_sts_error THEN
296: RAISE FND_API.g_exc_error;
297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
298: RAISE FND_API.g_exc_unexpected_error;
299: END IF;
300: END IF;

Line 297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

293: );
294:
295: IF l_return_status = FND_API.g_ret_sts_error THEN
296: RAISE FND_API.g_exc_error;
297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
298: RAISE FND_API.g_exc_unexpected_error;
299: END IF;
300: END IF;
301: -------------------------------------------------------

Line 298: RAISE FND_API.g_exc_unexpected_error;

294:
295: IF l_return_status = FND_API.g_ret_sts_error THEN
296: RAISE FND_API.g_exc_error;
297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
298: RAISE FND_API.g_exc_unexpected_error;
299: END IF;
300: END IF;
301: -------------------------------------------------------
302: --

Line 307: p_init_msg_list => FND_API.G_FALSE,

303: -- API body
304: --
305: AMS_DelivKitItem_PVT.Update_Deliv_Kit_Item(
306: p_api_version => 1.0,
307: p_init_msg_list => FND_API.G_FALSE,
308: p_commit => p_commit,
309: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
310: x_return_status => x_return_status,
311: x_msg_count => x_msg_count,

Line 309: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

305: AMS_DelivKitItem_PVT.Update_Deliv_Kit_Item(
306: p_api_version => 1.0,
307: p_init_msg_list => FND_API.G_FALSE,
308: p_commit => p_commit,
309: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
310: x_return_status => x_return_status,
311: x_msg_count => x_msg_count,
312: x_msg_data => x_msg_data,
313: p_Deliv_Kit_Item_rec => l_pvt_DelivKitItem_rec);

Line 317: IF x_return_status = FND_API.G_RET_STS_ERROR then

313: p_Deliv_Kit_Item_rec => l_pvt_DelivKitItem_rec);
314:
315:
316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: RAISE FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;

Line 318: RAISE FND_API.G_EXC_ERROR;

314:
315:
316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: RAISE FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: --

Line 319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

315:
316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: RAISE FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: --
323: -- End of API body

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: RAISE FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322: --
323: -- End of API body
324: --

Line 326: IF FND_API.to_Boolean( p_commit )

322: --
323: -- End of API body
324: --
325: -- Standard check for p_commit
326: IF FND_API.to_Boolean( p_commit )
327: THEN
328: COMMIT WORK;
329: END IF;
330:

Line 338: IF l_return_status = FND_API.g_ret_sts_error THEN

334: l_pvt_DelivKitItem_rec,
335: l_return_status
336: );
337:
338: IF l_return_status = FND_API.g_ret_sts_error THEN
339: RAISE FND_API.g_exc_error;
340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
341: RAISE FND_API.g_exc_unexpected_error;
342: END IF;

Line 339: RAISE FND_API.g_exc_error;

335: l_return_status
336: );
337:
338: IF l_return_status = FND_API.g_ret_sts_error THEN
339: RAISE FND_API.g_exc_error;
340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
341: RAISE FND_API.g_exc_unexpected_error;
342: END IF;
343: END IF;

Line 340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

336: );
337:
338: IF l_return_status = FND_API.g_ret_sts_error THEN
339: RAISE FND_API.g_exc_error;
340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
341: RAISE FND_API.g_exc_unexpected_error;
342: END IF;
343: END IF;
344:

Line 341: RAISE FND_API.g_exc_unexpected_error;

337:
338: IF l_return_status = FND_API.g_ret_sts_error THEN
339: RAISE FND_API.g_exc_error;
340: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
341: RAISE FND_API.g_exc_unexpected_error;
342: END IF;
343: END IF;
344:
345: -- vertical industry pre-processing

Line 353: IF l_return_status = FND_API.g_ret_sts_error THEN

349: l_pvt_DelivKitItem_rec,
350: l_return_status
351: );
352:
353: IF l_return_status = FND_API.g_ret_sts_error THEN
354: RAISE FND_API.g_exc_error;
355: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
356: RAISE FND_API.g_exc_unexpected_error;
357: END IF;

Line 354: RAISE FND_API.g_exc_error;

350: l_return_status
351: );
352:
353: IF l_return_status = FND_API.g_ret_sts_error THEN
354: RAISE FND_API.g_exc_error;
355: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
356: RAISE FND_API.g_exc_unexpected_error;
357: END IF;
358: END IF;

Line 355: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

351: );
352:
353: IF l_return_status = FND_API.g_ret_sts_error THEN
354: RAISE FND_API.g_exc_error;
355: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
356: RAISE FND_API.g_exc_unexpected_error;
357: END IF;
358: END IF;
359: -------------------------------------------------------

Line 356: RAISE FND_API.g_exc_unexpected_error;

352:
353: IF l_return_status = FND_API.g_ret_sts_error THEN
354: RAISE FND_API.g_exc_error;
355: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
356: RAISE FND_API.g_exc_unexpected_error;
357: END IF;
358: END IF;
359: -------------------------------------------------------
360: -- Debug Message

Line 371: x_return_status := FND_API.g_ret_sts_error;

367: );
368: EXCEPTION
369:
370: WHEN AMS_Utility_PVT.resource_locked THEN
371: x_return_status := FND_API.g_ret_sts_error;
372: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO UPDATE_DelivKitItem_PUB;

Line 374: WHEN FND_API.G_EXC_ERROR THEN

370: WHEN AMS_Utility_PVT.resource_locked THEN
371: x_return_status := FND_API.g_ret_sts_error;
372: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO UPDATE_DelivKitItem_PUB;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: -- Standard call to get message count and if count=1, get the message
378: FND_MSG_PUB.Count_And_Get (

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

372: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO UPDATE_DelivKitItem_PUB;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: -- Standard call to get message count and if count=1, get the message
378: FND_MSG_PUB.Count_And_Get (
379: p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,

Line 379: p_encoded => FND_API.G_FALSE,

375: ROLLBACK TO UPDATE_DelivKitItem_PUB;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: -- Standard call to get message count and if count=1, get the message
378: FND_MSG_PUB.Count_And_Get (
379: p_encoded => FND_API.G_FALSE,
380: p_count => x_msg_count,
381: p_data => x_msg_data
382: );
383:

Line 384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

380: p_count => x_msg_count,
381: p_data => x_msg_data
382: );
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO UPDATE_DelivKitItem_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Standard call to get message count and if count=1, get the message
388: FND_MSG_PUB.Count_And_Get (

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: );
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO UPDATE_DelivKitItem_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Standard call to get message count and if count=1, get the message
388: FND_MSG_PUB.Count_And_Get (
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,

Line 389: p_encoded => FND_API.G_FALSE,

385: ROLLBACK TO UPDATE_DelivKitItem_PUB;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: -- Standard call to get message count and if count=1, get the message
388: FND_MSG_PUB.Count_And_Get (
389: p_encoded => FND_API.G_FALSE,
390: p_count => x_msg_count,
391: p_data => x_msg_data
392: );
393:

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: );
393:
394: WHEN OTHERS THEN
395: ROLLBACK TO UPDATE_DelivKitItem_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
400: END IF;

Line 403: p_encoded => FND_API.G_FALSE,

399: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
400: END IF;
401: -- Standard call to get message count and if count=1, get the message
402: FND_MSG_PUB.Count_And_Get (
403: p_encoded => FND_API.G_FALSE,
404: p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407:

Line 413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

409:
410:
411: PROCEDURE Delete_DelivKitItem(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE,
415: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,

Line 414: p_commit IN VARCHAR2 := FND_API.G_FALSE,

410:
411: PROCEDURE Delete_DelivKitItem(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE,
415: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,

Line 415: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

411: PROCEDURE Delete_DelivKitItem(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_commit IN VARCHAR2 := FND_API.G_FALSE,
415: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2,
419: p_deliv_kit_item_id IN NUMBER,

Line 439: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

435: -- Standard Start of API savepoint
436: SAVEPOINT DELETE_DelivKitItem_PUB;
437:
438: -- Standard call to check for call compatibility.
439: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
440: p_api_version_number,
441: l_api_name,
442: G_PKG_NAME)
443: THEN

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: p_api_version_number,
441: l_api_name,
442: G_PKG_NAME)
443: THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )

Line 448: IF FND_API.to_Boolean( p_init_msg_list )

444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Initialize message list if p_init_msg_list is set to TRUE.
448: IF FND_API.to_Boolean( p_init_msg_list )
449: THEN
450: FND_MSG_PUB.initialize;
451: END IF;
452:

Line 458: x_return_status := FND_API.G_RET_STS_SUCCESS;

454: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
455:
456:
457: -- Initialize API return status to SUCCESS
458: x_return_status := FND_API.G_RET_STS_SUCCESS;
459:
460: -- customer pre-processing
461: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
462: THEN

Line 469: IF l_return_status = FND_API.g_ret_sts_error THEN

465: l_object_version_number,
466: l_return_status
467: );
468:
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;

Line 470: RAISE FND_API.g_exc_error;

466: l_return_status
467: );
468:
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;
474: END IF;

Line 471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

467: );
468:
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;
474: END IF;
475:

Line 472: RAISE FND_API.g_exc_unexpected_error;

468:
469: IF l_return_status = FND_API.g_ret_sts_error THEN
470: RAISE FND_API.g_exc_error;
471: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
472: RAISE FND_API.g_exc_unexpected_error;
473: END IF;
474: END IF;
475:
476: -- vertical industry pre-processing

Line 485: IF l_return_status = FND_API.g_ret_sts_error THEN

481: l_object_version_number,
482: l_return_status
483: );
484:
485: IF l_return_status = FND_API.g_ret_sts_error THEN
486: RAISE FND_API.g_exc_error;
487: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
488: RAISE FND_API.g_exc_unexpected_error;
489: END IF;

Line 486: RAISE FND_API.g_exc_error;

482: l_return_status
483: );
484:
485: IF l_return_status = FND_API.g_ret_sts_error THEN
486: RAISE FND_API.g_exc_error;
487: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
488: RAISE FND_API.g_exc_unexpected_error;
489: END IF;
490: END IF;

Line 487: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

483: );
484:
485: IF l_return_status = FND_API.g_ret_sts_error THEN
486: RAISE FND_API.g_exc_error;
487: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
488: RAISE FND_API.g_exc_unexpected_error;
489: END IF;
490: END IF;
491: -------------------------------------------------------

Line 488: RAISE FND_API.g_exc_unexpected_error;

484:
485: IF l_return_status = FND_API.g_ret_sts_error THEN
486: RAISE FND_API.g_exc_error;
487: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
488: RAISE FND_API.g_exc_unexpected_error;
489: END IF;
490: END IF;
491: -------------------------------------------------------
492:

Line 498: p_init_msg_list => FND_API.G_FALSE,

494: -- API body
495: --
496: AMS_DelivKitItem_PVT.Delete_Deliv_Kit_Item(
497: p_api_version => 1.0,
498: p_init_msg_list => FND_API.G_FALSE,
499: p_commit => p_commit,
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,

Line 509: IF x_return_status = FND_API.G_RET_STS_ERROR then

505:
506:
507:
508: -- Check return status from the above procedure call
509: IF x_return_status = FND_API.G_RET_STS_ERROR then
510: RAISE FND_API.G_EXC_ERROR;
511: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;

Line 510: RAISE FND_API.G_EXC_ERROR;

506:
507:
508: -- Check return status from the above procedure call
509: IF x_return_status = FND_API.G_RET_STS_ERROR then
510: RAISE FND_API.G_EXC_ERROR;
511: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: --

Line 511: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

507:
508: -- Check return status from the above procedure call
509: IF x_return_status = FND_API.G_RET_STS_ERROR then
510: RAISE FND_API.G_EXC_ERROR;
511: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: --
515: -- End of API body

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: -- Check return status from the above procedure call
509: IF x_return_status = FND_API.G_RET_STS_ERROR then
510: RAISE FND_API.G_EXC_ERROR;
511: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: --
515: -- End of API body
516: --

Line 527: IF l_return_status = FND_API.g_ret_sts_error THEN

523: l_object_version_number,
524: l_return_status
525: );
526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;

Line 528: RAISE FND_API.g_exc_error;

524: l_return_status
525: );
526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;
532: END IF;

Line 529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

525: );
526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;
532: END IF;
533:

Line 530: RAISE FND_API.g_exc_unexpected_error;

526:
527: IF l_return_status = FND_API.g_ret_sts_error THEN
528: RAISE FND_API.g_exc_error;
529: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
530: RAISE FND_API.g_exc_unexpected_error;
531: END IF;
532: END IF;
533:
534: -- vertical industry pre-processing

Line 543: IF l_return_status = FND_API.g_ret_sts_error THEN

539: l_object_version_number,
540: l_return_status
541: );
542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;

Line 544: RAISE FND_API.g_exc_error;

540: l_return_status
541: );
542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;
548: END IF;

Line 545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

541: );
542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;
548: END IF;
549: -------------------------------------------------------

Line 546: RAISE FND_API.g_exc_unexpected_error;

542:
543: IF l_return_status = FND_API.g_ret_sts_error THEN
544: RAISE FND_API.g_exc_error;
545: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
546: RAISE FND_API.g_exc_unexpected_error;
547: END IF;
548: END IF;
549: -------------------------------------------------------
550:

Line 553: IF FND_API.to_Boolean( p_commit )

549: -------------------------------------------------------
550:
551:
552: -- Standard check for p_commit
553: IF FND_API.to_Boolean( p_commit )
554: THEN
555: COMMIT WORK;
556: END IF;
557:

Line 570: x_return_status := FND_API.g_ret_sts_error;

566: );
567: EXCEPTION
568:
569: WHEN AMS_Utility_PVT.resource_locked THEN
570: x_return_status := FND_API.g_ret_sts_error;
571: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO DELETE_DelivKitItem_PUB;

Line 573: WHEN FND_API.G_EXC_ERROR THEN

569: WHEN AMS_Utility_PVT.resource_locked THEN
570: x_return_status := FND_API.g_ret_sts_error;
571: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO DELETE_DelivKitItem_PUB;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (

Line 575: x_return_status := FND_API.G_RET_STS_ERROR;

571: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO DELETE_DelivKitItem_PUB;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,

Line 578: p_encoded => FND_API.G_FALSE,

574: ROLLBACK TO DELETE_DelivKitItem_PUB;
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );
582:

Line 583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );
582:
583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: ROLLBACK TO DELETE_DelivKitItem_PUB;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581: );
582:
583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: ROLLBACK TO DELETE_DelivKitItem_PUB;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,

Line 588: p_encoded => FND_API.G_FALSE,

584: ROLLBACK TO DELETE_DelivKitItem_PUB;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: -- Standard call to get message count and if count=1, get the message
587: FND_MSG_PUB.Count_And_Get (
588: p_encoded => FND_API.G_FALSE,
589: p_count => x_msg_count,
590: p_data => x_msg_data
591: );
592:

Line 595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

591: );
592:
593: WHEN OTHERS THEN
594: ROLLBACK TO DELETE_DelivKitItem_PUB;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;

Line 602: p_encoded => FND_API.G_FALSE,

598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
599: END IF;
600: -- Standard call to get message count and if count=1, get the message
601: FND_MSG_PUB.Count_And_Get (
602: p_encoded => FND_API.G_FALSE,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );
606: End Delete_DelivKitItem;

Line 613: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

609:
610:
611: PROCEDURE Validate_DelivKitItem(
612: p_api_version_number IN NUMBER,
613: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
614: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
615: x_return_status OUT NOCOPY VARCHAR2,
616: x_msg_count OUT NOCOPY NUMBER,
617: x_msg_data OUT NOCOPY VARCHAR2,

Line 614: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

610:
611: PROCEDURE Validate_DelivKitItem(
612: p_api_version_number IN NUMBER,
613: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
614: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
615: x_return_status OUT NOCOPY VARCHAR2,
616: x_msg_count OUT NOCOPY NUMBER,
617: x_msg_data OUT NOCOPY VARCHAR2,
618: p_Deliv_Kit_Item_rec IN AMS_DelivKitItem_PVT.deliv_kit_item_rec_type

Line 635: IF FND_API.to_boolean(p_init_msg_list) THEN

631: SAVEPOINT validate_DelivKitItem_pub;
632:
633: -- initialize the message list;
634: -- won't do it again when calling private API
635: IF FND_API.to_boolean(p_init_msg_list) THEN
636: FND_MSG_PUB.initialize;
637: END IF;
638:
639: -- customer pre-processing

Line 647: IF l_return_status = FND_API.g_ret_sts_error THEN

643: l_pvt_DelivKitItem_rec,
644: l_return_status
645: );
646:
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;

Line 648: RAISE FND_API.g_exc_error;

644: l_return_status
645: );
646:
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: END IF;

Line 649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

645: );
646:
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: END IF;
653:

Line 650: RAISE FND_API.g_exc_unexpected_error;

646:
647: IF l_return_status = FND_API.g_ret_sts_error THEN
648: RAISE FND_API.g_exc_error;
649: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
650: RAISE FND_API.g_exc_unexpected_error;
651: END IF;
652: END IF;
653:
654: -- vertical industry pre-processing

Line 662: IF l_return_status = FND_API.g_ret_sts_error THEN

658: l_pvt_DelivKitItem_rec,
659: l_return_status
660: );
661:
662: IF l_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
665: RAISE FND_API.g_exc_unexpected_error;
666: END IF;

Line 663: RAISE FND_API.g_exc_error;

659: l_return_status
660: );
661:
662: IF l_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
665: RAISE FND_API.g_exc_unexpected_error;
666: END IF;
667: END IF;

Line 664: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

660: );
661:
662: IF l_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
665: RAISE FND_API.g_exc_unexpected_error;
666: END IF;
667: END IF;
668:

Line 665: RAISE FND_API.g_exc_unexpected_error;

661:
662: IF l_return_status = FND_API.g_ret_sts_error THEN
663: RAISE FND_API.g_exc_error;
664: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
665: RAISE FND_API.g_exc_unexpected_error;
666: END IF;
667: END IF;
668:
669: -- call business API

Line 682: IF l_return_status = FND_API.g_ret_sts_error THEN

678: x_msg_data => x_msg_data
679: );
680:
681:
682: IF l_return_status = FND_API.g_ret_sts_error THEN
683: RAISE FND_API.g_exc_error;
684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
685: RAISE FND_API.g_exc_unexpected_error;
686: END IF;

Line 683: RAISE FND_API.g_exc_error;

679: );
680:
681:
682: IF l_return_status = FND_API.g_ret_sts_error THEN
683: RAISE FND_API.g_exc_error;
684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
685: RAISE FND_API.g_exc_unexpected_error;
686: END IF;
687:

Line 684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

680:
681:
682: IF l_return_status = FND_API.g_ret_sts_error THEN
683: RAISE FND_API.g_exc_error;
684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
685: RAISE FND_API.g_exc_unexpected_error;
686: END IF;
687:
688:

Line 685: RAISE FND_API.g_exc_unexpected_error;

681:
682: IF l_return_status = FND_API.g_ret_sts_error THEN
683: RAISE FND_API.g_exc_error;
684: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
685: RAISE FND_API.g_exc_unexpected_error;
686: END IF;
687:
688:
689:

Line 700: IF l_return_status = FND_API.g_ret_sts_error THEN

696: l_pvt_DelivKitItem_rec,
697: l_return_status
698: );
699:
700: IF l_return_status = FND_API.g_ret_sts_error THEN
701: RAISE FND_API.g_exc_error;
702: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: END IF;

Line 701: RAISE FND_API.g_exc_error;

697: l_return_status
698: );
699:
700: IF l_return_status = FND_API.g_ret_sts_error THEN
701: RAISE FND_API.g_exc_error;
702: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: END IF;
705: END IF;

Line 702: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

698: );
699:
700: IF l_return_status = FND_API.g_ret_sts_error THEN
701: RAISE FND_API.g_exc_error;
702: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: END IF;
705: END IF;
706:

Line 703: RAISE FND_API.g_exc_unexpected_error;

699:
700: IF l_return_status = FND_API.g_ret_sts_error THEN
701: RAISE FND_API.g_exc_error;
702: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: END IF;
705: END IF;
706:
707: -- customer post-processing

Line 715: IF l_return_status = FND_API.g_ret_sts_error THEN

711: l_pvt_DelivKitItem_rec,
712: l_return_status
713: );
714:
715: IF l_return_status = FND_API.g_ret_sts_error THEN
716: RAISE FND_API.g_exc_error;
717: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;

Line 716: RAISE FND_API.g_exc_error;

712: l_return_status
713: );
714:
715: IF l_return_status = FND_API.g_ret_sts_error THEN
716: RAISE FND_API.g_exc_error;
717: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;
720: END IF;

Line 717: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

713: );
714:
715: IF l_return_status = FND_API.g_ret_sts_error THEN
716: RAISE FND_API.g_exc_error;
717: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;
720: END IF;
721:

Line 718: RAISE FND_API.g_exc_unexpected_error;

714:
715: IF l_return_status = FND_API.g_ret_sts_error THEN
716: RAISE FND_API.g_exc_error;
717: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;
720: END IF;
721:
722: -- Debug Message

Line 733: WHEN FND_API.g_exc_error THEN

729: );
730:
731: EXCEPTION
732:
733: WHEN FND_API.g_exc_error THEN
734: ROLLBACK TO validate_DelivKitItem_pub;
735: x_return_status := FND_API.g_ret_sts_error;
736: FND_MSG_PUB.count_and_get(
737: p_encoded => FND_API.g_false,

Line 735: x_return_status := FND_API.g_ret_sts_error;

731: EXCEPTION
732:
733: WHEN FND_API.g_exc_error THEN
734: ROLLBACK TO validate_DelivKitItem_pub;
735: x_return_status := FND_API.g_ret_sts_error;
736: FND_MSG_PUB.count_and_get(
737: p_encoded => FND_API.g_false,
738: p_count => x_msg_count,
739: p_data => x_msg_data

Line 737: p_encoded => FND_API.g_false,

733: WHEN FND_API.g_exc_error THEN
734: ROLLBACK TO validate_DelivKitItem_pub;
735: x_return_status := FND_API.g_ret_sts_error;
736: FND_MSG_PUB.count_and_get(
737: p_encoded => FND_API.g_false,
738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );
741:

Line 742: WHEN FND_API.g_exc_unexpected_error THEN

738: p_count => x_msg_count,
739: p_data => x_msg_data
740: );
741:
742: WHEN FND_API.g_exc_unexpected_error THEN
743: ROLLBACK TO validate_DelivKitItem_pub;
744: x_return_status := FND_API.g_ret_sts_unexp_error ;
745: FND_MSG_PUB.count_and_get(
746: p_encoded => FND_API.g_false,

Line 744: x_return_status := FND_API.g_ret_sts_unexp_error ;

740: );
741:
742: WHEN FND_API.g_exc_unexpected_error THEN
743: ROLLBACK TO validate_DelivKitItem_pub;
744: x_return_status := FND_API.g_ret_sts_unexp_error ;
745: FND_MSG_PUB.count_and_get(
746: p_encoded => FND_API.g_false,
747: p_count => x_msg_count,
748: p_data => x_msg_data

Line 746: p_encoded => FND_API.g_false,

742: WHEN FND_API.g_exc_unexpected_error THEN
743: ROLLBACK TO validate_DelivKitItem_pub;
744: x_return_status := FND_API.g_ret_sts_unexp_error ;
745: FND_MSG_PUB.count_and_get(
746: p_encoded => FND_API.g_false,
747: p_count => x_msg_count,
748: p_data => x_msg_data
749: );
750:

Line 754: x_return_status := FND_API.g_ret_sts_unexp_error ;

750:
751:
752: WHEN OTHERS THEN
753: ROLLBACK TO validate_DelivKitItem_pub;
754: x_return_status := FND_API.g_ret_sts_unexp_error ;
755:
756: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
757: THEN
758: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 762: p_encoded => FND_API.g_false,

758: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
759: END IF;
760:
761: FND_MSG_PUB.count_and_get(
762: p_encoded => FND_API.g_false,
763: p_count => x_msg_count,
764: p_data => x_msg_data
765: );
766:

Line 772: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

768:
769:
770: PROCEDURE Lock_DelivKitItem(
771: p_api_version_number IN NUMBER,
772: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
773:
774: x_return_status OUT NOCOPY VARCHAR2,
775: x_msg_count OUT NOCOPY NUMBER,
776: x_msg_data OUT NOCOPY VARCHAR2,

Line 794: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

790:
791: BEGIN
792:
793: -- Standard call to check for call compatibility.
794: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
795: p_api_version_number,
796: l_api_name,
797: G_PKG_NAME)
798: THEN

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: p_api_version_number,
796: l_api_name,
797: G_PKG_NAME)
798: THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list )

Line 803: IF FND_API.to_Boolean( p_init_msg_list )

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list )
804: THEN
805: FND_MSG_PUB.initialize;
806: END IF;
807:

Line 813: x_return_status := FND_API.G_RET_STS_SUCCESS;

809: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
810:
811:
812: -- Initialize API return status to SUCCESS
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814: --
815: -- customer pre-processing
816: IF JTF_USR_HKS.ok_to_execute(g_pkg_name, l_api_name, 'B', 'C')
817: THEN

Line 824: IF l_return_status = FND_API.g_ret_sts_error THEN

820: l_object_version_number,
821: l_return_status
822: );
823:
824: IF l_return_status = FND_API.g_ret_sts_error THEN
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: RAISE FND_API.g_exc_unexpected_error;
828: END IF;

Line 825: RAISE FND_API.g_exc_error;

821: l_return_status
822: );
823:
824: IF l_return_status = FND_API.g_ret_sts_error THEN
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: RAISE FND_API.g_exc_unexpected_error;
828: END IF;
829: END IF;

Line 826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

822: );
823:
824: IF l_return_status = FND_API.g_ret_sts_error THEN
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: RAISE FND_API.g_exc_unexpected_error;
828: END IF;
829: END IF;
830:

Line 827: RAISE FND_API.g_exc_unexpected_error;

823:
824: IF l_return_status = FND_API.g_ret_sts_error THEN
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: RAISE FND_API.g_exc_unexpected_error;
828: END IF;
829: END IF;
830:
831: -- vertical industry pre-processing

Line 840: IF l_return_status = FND_API.g_ret_sts_error THEN

836: l_object_version_number,
837: l_return_status
838: );
839:
840: IF l_return_status = FND_API.g_ret_sts_error THEN
841: RAISE FND_API.g_exc_error;
842: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
843: RAISE FND_API.g_exc_unexpected_error;
844: END IF;

Line 841: RAISE FND_API.g_exc_error;

837: l_return_status
838: );
839:
840: IF l_return_status = FND_API.g_ret_sts_error THEN
841: RAISE FND_API.g_exc_error;
842: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
843: RAISE FND_API.g_exc_unexpected_error;
844: END IF;
845: END IF;

Line 842: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

838: );
839:
840: IF l_return_status = FND_API.g_ret_sts_error THEN
841: RAISE FND_API.g_exc_error;
842: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
843: RAISE FND_API.g_exc_unexpected_error;
844: END IF;
845: END IF;
846: --

Line 843: RAISE FND_API.g_exc_unexpected_error;

839:
840: IF l_return_status = FND_API.g_ret_sts_error THEN
841: RAISE FND_API.g_exc_error;
842: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
843: RAISE FND_API.g_exc_unexpected_error;
844: END IF;
845: END IF;
846: --
847: -- API body

Line 854: p_init_msg_list => FND_API.G_FALSE,

850: -- Hint: Primary key needs to be returned
851:
852: AMS_DelivKitItem_PVT.Lock_Deliv_Kit_Item(
853: p_api_version => 1.0,
854: p_init_msg_list => FND_API.G_FALSE,
855: x_return_status => x_return_status,
856: x_msg_count => x_msg_count,
857: x_msg_data => x_msg_data,
858: p_deliv_kit_item_id => l_deliv_kit_item_id,

Line 863: IF x_return_status = FND_API.G_RET_STS_ERROR then

859: p_object_version => l_object_version_number);
860:
861:
862: -- Check return status from the above procedure call
863: IF x_return_status = FND_API.G_RET_STS_ERROR then
864: RAISE FND_API.G_EXC_ERROR;
865: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;

Line 864: RAISE FND_API.G_EXC_ERROR;

860:
861:
862: -- Check return status from the above procedure call
863: IF x_return_status = FND_API.G_RET_STS_ERROR then
864: RAISE FND_API.G_EXC_ERROR;
865: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: --

Line 865: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

861:
862: -- Check return status from the above procedure call
863: IF x_return_status = FND_API.G_RET_STS_ERROR then
864: RAISE FND_API.G_EXC_ERROR;
865: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: --
869: -- End of API body.

Line 866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

862: -- Check return status from the above procedure call
863: IF x_return_status = FND_API.G_RET_STS_ERROR then
864: RAISE FND_API.G_EXC_ERROR;
865: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
867: END IF;
868: --
869: -- End of API body.
870: --

Line 880: IF l_return_status = FND_API.g_ret_sts_error THEN

876: l_object_version_number,
877: l_return_status
878: );
879:
880: IF l_return_status = FND_API.g_ret_sts_error THEN
881: RAISE FND_API.g_exc_error;
882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
883: RAISE FND_API.g_exc_unexpected_error;
884: END IF;

Line 881: RAISE FND_API.g_exc_error;

877: l_return_status
878: );
879:
880: IF l_return_status = FND_API.g_ret_sts_error THEN
881: RAISE FND_API.g_exc_error;
882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
883: RAISE FND_API.g_exc_unexpected_error;
884: END IF;
885: END IF;

Line 882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

878: );
879:
880: IF l_return_status = FND_API.g_ret_sts_error THEN
881: RAISE FND_API.g_exc_error;
882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
883: RAISE FND_API.g_exc_unexpected_error;
884: END IF;
885: END IF;
886:

Line 883: RAISE FND_API.g_exc_unexpected_error;

879:
880: IF l_return_status = FND_API.g_ret_sts_error THEN
881: RAISE FND_API.g_exc_error;
882: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
883: RAISE FND_API.g_exc_unexpected_error;
884: END IF;
885: END IF;
886:
887: -- vertical industry pre-processing

Line 896: IF l_return_status = FND_API.g_ret_sts_error THEN

892: l_object_version_number,
893: l_return_status
894: );
895:
896: IF l_return_status = FND_API.g_ret_sts_error THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;

Line 897: RAISE FND_API.g_exc_error;

893: l_return_status
894: );
895:
896: IF l_return_status = FND_API.g_ret_sts_error THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;
901: END IF;

Line 898: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

894: );
895:
896: IF l_return_status = FND_API.g_ret_sts_error THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;
901: END IF;
902: --

Line 899: RAISE FND_API.g_exc_unexpected_error;

895:
896: IF l_return_status = FND_API.g_ret_sts_error THEN
897: RAISE FND_API.g_exc_error;
898: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
899: RAISE FND_API.g_exc_unexpected_error;
900: END IF;
901: END IF;
902: --
903:

Line 910: x_return_status := FND_API.g_ret_sts_error;

906:
907: EXCEPTION
908:
909: WHEN AMS_Utility_PVT.resource_locked THEN
910: x_return_status := FND_API.g_ret_sts_error;
911: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: ROLLBACK TO LOCK_DelivKitItem_PUB;

Line 913: WHEN FND_API.G_EXC_ERROR THEN

909: WHEN AMS_Utility_PVT.resource_locked THEN
910: x_return_status := FND_API.g_ret_sts_error;
911: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: ROLLBACK TO LOCK_DelivKitItem_PUB;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: ROLLBACK TO LOCK_DelivKitItem_PUB;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,

Line 918: p_encoded => FND_API.G_FALSE,

914: ROLLBACK TO LOCK_DelivKitItem_PUB;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: -- Standard call to get message count and if count=1, get the message
917: FND_MSG_PUB.Count_And_Get (
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );
922:

Line 923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

919: p_count => x_msg_count,
920: p_data => x_msg_data
921: );
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: ROLLBACK TO LOCK_DelivKitItem_PUB;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

921: );
922:
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: ROLLBACK TO LOCK_DelivKitItem_PUB;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (
928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,

Line 928: p_encoded => FND_API.G_FALSE,

924: ROLLBACK TO LOCK_DelivKitItem_PUB;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (
928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data
931: );
932:

Line 935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

931: );
932:
933: WHEN OTHERS THEN
934: ROLLBACK TO LOCK_DelivKitItem_PUB;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
937: THEN
938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
939: END IF;

Line 942: p_encoded => FND_API.G_FALSE,

938: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
939: END IF;
940: -- Standard call to get message count and if count=1, get the message
941: FND_MSG_PUB.Count_And_Get (
942: p_encoded => FND_API.G_FALSE,
943: p_count => x_msg_count,
944: p_data => x_msg_data
945: );
946: End Lock_DelivKitItem;