DBA Data[Home] [Help]

APPS.WMS_CYCLE_PVT dependencies on STANDARD

Line 20: --with GSCC File.Sql.39 standard Bug:4410902

16: -- dbms_output.put_line(p_err_msg);
17: END print_debug;
18:
19: --Added NOCOPY hint to x_return_status,x_msg_count,x_msg_data to comply
20: --with GSCC File.Sql.39 standard Bug:4410902
21:
22: /* Bug 7504490 - Modified the procedure. Added the parameter p_pn_id and p_revision
23: to create CC entries for an LPN when a short pick was for an allocated lpn */
24: PROCEDURE Create_Unscheduled_Counts

Line 62: -- Standard Start of API savepoint

58: l_count NUMBER := 0; --Bug 9874049
59:
60: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT Create_Unscheduled_Counts_PVT;
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,

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

60: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT Create_Unscheduled_Counts_PVT;
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME )

Line 342: -- Standard check of p_commit.

338: COMMIT;
339: END IF;
340:
341: -- End of API body
342: -- Standard check of p_commit.
343: IF FND_API.To_Boolean( p_commit ) THEN
344: COMMIT WORK;
345: END IF;
346: -- Standard call to get message count and if count is 1,

Line 346: -- Standard call to get message count and if count is 1,

342: -- Standard check of p_commit.
343: IF FND_API.To_Boolean( p_commit ) THEN
344: COMMIT WORK;
345: END IF;
346: -- Standard call to get message count and if count is 1,
347: -- get message info.
348: FND_MSG_PUB.Count_And_Get
349: ( p_count => x_msg_count,
350: p_data => x_msg_data