75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2 (2000);
77: BEGIN
78: --
79: -- Standard Start of API savepoint
80: SAVEPOINT CREATE_REPAIR_ORDER_PUB;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
83: p_api_version_number,
77: BEGIN
78: --
79: -- Standard Start of API savepoint
80: SAVEPOINT CREATE_REPAIR_ORDER_PUB;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
152:
153: --
154: -- End of API body.
155: --
156: -- Standard check for p_commit
157: IF FND_API.to_Boolean(p_commit)
158: THEN
159: COMMIT WORK;
160: END IF;
157: IF FND_API.to_Boolean(p_commit)
158: THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard call to get message count and if count is 1, get message info.
162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
163: p_data => x_msg_data);
164: --
165: EXCEPTION
209: l_api_version_number CONSTANT NUMBER := 1.0;
210: --
211: BEGIN
212: --
213: -- Standard Start of API savepoint
214: SAVEPOINT UPDATE_REPAIR_ORDER_PUB;
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
217: p_api_version_number,
211: BEGIN
212: --
213: -- Standard Start of API savepoint
214: SAVEPOINT UPDATE_REPAIR_ORDER_PUB;
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
248: END IF;
249: --
250: -- End of API body.
251: --
252: -- Standard check for p_commit
253: IF FND_API.to_Boolean(p_commit)
254: THEN
255: COMMIT WORK;
256: END IF;
253: IF FND_API.to_Boolean(p_commit)
254: THEN
255: COMMIT WORK;
256: END IF;
257: -- Standard call to get message count and if count is 1, get message info.
258: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
259: p_data => x_msg_data);
260: --
261: EXCEPTION
320: l_api_version_number CONSTANT NUMBER := 1.0;
321: --
322: BEGIN
323: --
324: -- Standard Start of API savepoint
325: SAVEPOINT UPDATE_RO_STATUS_PUB;
326: -- Standard call to check for call compatibility.
327: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
328: p_api_version,
322: BEGIN
323: --
324: -- Standard Start of API savepoint
325: SAVEPOINT UPDATE_RO_STATUS_PUB;
326: -- Standard call to check for call compatibility.
327: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
328: p_api_version,
329: l_api_name,
330: G_PKG_NAME)
360: END IF;
361: --
362: -- End of API body.
363: --
364: -- Standard check for p_commit
365: IF FND_API.to_Boolean(p_commit)
366: THEN
367: COMMIT WORK;
368: END IF;
365: IF FND_API.to_Boolean(p_commit)
366: THEN
367: COMMIT WORK;
368: END IF;
369: -- Standard call to get message count and if count is 1, get message info.
370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
371: p_data => x_msg_data);
372: --
373: EXCEPTION