DBA Data[Home] [Help]

APPS.AMS_IS_LINE_PUB dependencies on STANDARD

Line 42: -- Standard Start of API savepoint

38: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Is_Line';
39: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
40: l_pvt_is_line_rec AMS_Is_Line_PVT.is_line_rec_type;
41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_Is_Line_PUB;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 45: -- Standard call to check for call compatibility.

41: BEGIN
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_Is_Line_PUB;
44:
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)

Line 97: -- Standard check for p_commit

93: --
94: -- End of API body.
95: --
96:
97: -- Standard check for p_commit
98: IF FND_API.to_Boolean( p_commit )
99: THEN
100: COMMIT WORK;
101: END IF;

Line 110: -- Standard call to get message count and if count is 1, get message info.

106:
107: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
108: END IF;
109:
110: -- Standard call to get message count and if count is 1, get message info.
111: FND_MSG_PUB.Count_And_Get
112: (p_count => x_msg_count,
113: p_data => x_msg_data
114: );

Line 124: -- Standard call to get message count and if count=1, get the message

120:
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO CREATE_Is_Line_PUB;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: -- Standard call to get message count and if count=1, get the message
125: FND_MSG_PUB.Count_And_Get (
126: p_encoded => FND_API.G_FALSE,
127: p_count => x_msg_count,
128: p_data => x_msg_data

Line 134: -- Standard call to get message count and if count=1, get the message

130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_Is_Line_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: -- Standard call to get message count and if count=1, get the message
135: FND_MSG_PUB.Count_And_Get (
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,
138: p_data => x_msg_data

Line 148: -- Standard call to get message count and if count=1, get the message

144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data

Line 176: -- Standard Start of API savepoint

172: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
173: l_object_version_number NUMBER;
174: l_pvt_is_line_rec AMS_Is_Line_PVT.is_line_rec_type;
175: BEGIN
176: -- Standard Start of API savepoint
177: SAVEPOINT UPDATE_Is_Line_PUB;
178:
179: -- Standard call to check for call compatibility.
180: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 179: -- Standard call to check for call compatibility.

175: BEGIN
176: -- Standard Start of API savepoint
177: SAVEPOINT UPDATE_Is_Line_PUB;
178:
179: -- Standard call to check for call compatibility.
180: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
181: p_api_version_number,
182: l_api_name,
183: G_PKG_NAME)

Line 229: -- Standard check for p_commit

225: --
226: -- End of API body
227: --
228:
229: -- Standard check for p_commit
230: IF FND_API.to_Boolean( p_commit )
231: THEN
232: COMMIT WORK;
233: END IF;

Line 242: -- Standard call to get message count and if count is 1, get message info.

238:
239: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
240: END IF;
241:
242: -- Standard call to get message count and if count is 1, get message info.
243: FND_MSG_PUB.Count_And_Get
244: (p_count => x_msg_count,
245: p_data => x_msg_data
246: );

Line 256: -- Standard call to get message count and if count=1, get the message

252:
253: WHEN FND_API.G_EXC_ERROR THEN
254: ROLLBACK TO UPDATE_Is_Line_PUB;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: -- Standard call to get message count and if count=1, get the message
257: FND_MSG_PUB.Count_And_Get (
258: p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => x_msg_data

Line 266: -- Standard call to get message count and if count=1, get the message

262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: ROLLBACK TO UPDATE_Is_Line_PUB;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data

Line 280: -- Standard call to get message count and if count=1, get the message

276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
279: END IF;
280: -- Standard call to get message count and if count=1, get the message
281: FND_MSG_PUB.Count_And_Get (
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data

Line 307: -- Standard Start of API savepoint

303: l_IMPORT_SOURCE_LINE_ID NUMBER := p_IMPORT_SOURCE_LINE_ID;
304: l_object_version_number NUMBER := p_object_version_number;
305: l_pvt_is_line_rec AMS_Is_Line_PVT.is_line_rec_type;
306: BEGIN
307: -- Standard Start of API savepoint
308: SAVEPOINT DELETE_Is_Line_PUB;
309:
310: -- Standard call to check for call compatibility.
311: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 310: -- Standard call to check for call compatibility.

306: BEGIN
307: -- Standard Start of API savepoint
308: SAVEPOINT DELETE_Is_Line_PUB;
309:
310: -- Standard call to check for call compatibility.
311: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
312: p_api_version_number,
313: l_api_name,
314: G_PKG_NAME)

Line 360: -- Standard check for p_commit

356: --
357: -- End of API body
358: --
359:
360: -- Standard check for p_commit
361: IF FND_API.to_Boolean( p_commit )
362: THEN
363: COMMIT WORK;
364: END IF;

Line 373: -- Standard call to get message count and if count is 1, get message info.

369:
370: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
371: END IF;
372:
373: -- Standard call to get message count and if count is 1, get message info.
374: FND_MSG_PUB.Count_And_Get
375: (p_count => x_msg_count,
376: p_data => x_msg_data
377: );

Line 387: -- Standard call to get message count and if count=1, get the message

383:
384: WHEN FND_API.G_EXC_ERROR THEN
385: ROLLBACK TO DELETE_Is_Line_PUB;
386: x_return_status := FND_API.G_RET_STS_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

Line 397: -- Standard call to get message count and if count=1, get the message

393:
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO DELETE_Is_Line_PUB;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: -- Standard call to get message count and if count=1, get the message
398: FND_MSG_PUB.Count_And_Get (
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data

Line 411: -- Standard call to get message count and if count=1, get the message

407: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
410: END IF;
411: -- Standard call to get message count and if count=1, get the message
412: FND_MSG_PUB.Count_And_Get (
413: p_encoded => FND_API.G_FALSE,
414: p_count => x_msg_count,
415: p_data => x_msg_data

Line 437: -- Standard call to check for call compatibility.

433: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
434: l_pvt_is_line_rec AMS_Is_Line_PVT.is_line_rec_type;
435: BEGIN
436:
437: -- Standard call to check for call compatibility.
438: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
439: p_api_version_number,
440: l_api_name,
441: G_PKG_NAME)

Line 502: -- Standard call to get message count and if count=1, get the message

498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO LOCK_Is_Line_PUB;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get (
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data

Line 512: -- Standard call to get message count and if count=1, get the message

508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO LOCK_Is_Line_PUB;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data

Line 526: -- Standard call to get message count and if count=1, get the message

522: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
523: THEN
524: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
525: END IF;
526: -- Standard call to get message count and if count=1, get the message
527: FND_MSG_PUB.Count_And_Get (
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data