49: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATE_HEADER';
50: l_api_version CONSTANT NUMBER := 1.0;
51:
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT CREATE_ESTIMATE_HEADER_PUB;
55: -- Standard call to check for call compatibility.
56: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
57: p_api_version,
51:
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT CREATE_ESTIMATE_HEADER_PUB;
55: -- Standard call to check for call compatibility.
56: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
57: p_api_version,
58: l_api_name,
59: G_PKG_NAME)
88: END IF;
89: --
90: -- End of API body.
91: --
92: -- Standard check for p_commit
93: IF Fnd_Api.to_Boolean(p_commit)
94: THEN
95: COMMIT WORK;
96: END IF;
93: IF Fnd_Api.to_Boolean(p_commit)
94: THEN
95: COMMIT WORK;
96: END IF;
97: -- Standard call to get message count and if count is 1, get message info.
98: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
99: p_data => x_msg_data);
100: --
101: EXCEPTION
174: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_HEADER';
175: l_api_version CONSTANT NUMBER := 1.0;
176:
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT UPDATE_ESTIMATE_HEADER_PUB;
180: -- Standard call to check for call compatibility.
181: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
182: p_api_version,
176:
177: BEGIN
178: -- Standard Start of API savepoint
179: SAVEPOINT UPDATE_ESTIMATE_HEADER_PUB;
180: -- Standard call to check for call compatibility.
181: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
182: p_api_version,
183: l_api_name,
184: G_PKG_NAME)
214: END IF;
215: --
216: -- End of API body.
217: --
218: -- Standard check for p_commit
219: IF Fnd_Api.to_Boolean(p_commit)
220: THEN
221: COMMIT WORK;
222: END IF;
219: IF Fnd_Api.to_Boolean(p_commit)
220: THEN
221: COMMIT WORK;
222: END IF;
223: -- Standard call to get message count and if count is 1, get message info.
224: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
225: p_data => x_msg_data);
226: --
227: EXCEPTION
303: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATE_LINE';
304: l_api_version CONSTANT NUMBER := 1.0;
305:
306: BEGIN
307: -- Standard Start of API savepoint
308: SAVEPOINT CREATE_ESTIMATE_LINE_PUB;
309: -- Standard call to check for call compatibility.
310: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
311: p_api_version,
305:
306: BEGIN
307: -- Standard Start of API savepoint
308: SAVEPOINT CREATE_ESTIMATE_LINE_PUB;
309: -- Standard call to check for call compatibility.
310: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
311: p_api_version,
312: l_api_name,
313: G_PKG_NAME)
342: END IF;
343: --
344: -- End of API body.
345: --
346: -- Standard check for p_commit
347: IF Fnd_Api.to_Boolean(p_commit)
348: THEN
349: COMMIT WORK;
350: END IF;
347: IF Fnd_Api.to_Boolean(p_commit)
348: THEN
349: COMMIT WORK;
350: END IF;
351: -- Standard call to get message count and if count is 1, get message info.
352: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
353: p_data => x_msg_data);
354: --
355: EXCEPTION
431: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_LINE';
432: l_api_version CONSTANT NUMBER := 1.0;
433:
434: BEGIN
435: -- Standard Start of API savepoint
436: SAVEPOINT UPDATE_ESTIMATE_LINE_PUB;
437: -- Standard call to check for call compatibility.
438: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
439: p_api_version,
433:
434: BEGIN
435: -- Standard Start of API savepoint
436: SAVEPOINT UPDATE_ESTIMATE_LINE_PUB;
437: -- Standard call to check for call compatibility.
438: IF NOT Fnd_Api.Compatible_API_Call(l_api_version,
439: p_api_version,
440: l_api_name,
441: G_PKG_NAME)
470: END IF;
471: --
472: -- End of API body.
473: --
474: -- Standard check for p_commit
475: IF Fnd_Api.to_Boolean(p_commit)
476: THEN
477: COMMIT WORK;
478: END IF;
475: IF Fnd_Api.to_Boolean(p_commit)
476: THEN
477: COMMIT WORK;
478: END IF;
479: -- Standard call to get message count and if count is 1, get message info.
480: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
481: p_data => x_msg_data);
482: --
483: EXCEPTION