DBA Data[Home] [Help]

APPS.WMS_CONTAINER2_PUB dependencies on STANDARD

Line 75: -- Standard Start of API savepoint

71: WHERE lpn_id = p_lpn_id);
72:
73: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
74: BEGIN
75: -- Standard Start of API savepoint
76: SAVEPOINT Purge_LPN_PUB;
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
79: p_api_version ,

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

73: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
74: BEGIN
75: -- Standard Start of API savepoint
76: SAVEPOINT Purge_LPN_PUB;
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
79: p_api_version ,
80: l_api_name ,
81: G_PKG_NAME )

Line 164: -- Standard check of p_commit.

160: END IF;
161:
162: -- End of API body
163:
164: -- Standard check of p_commit.
165: IF FND_API.To_Boolean( p_commit ) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard call to get message count and if count is 1,

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

164: -- Standard check of p_commit.
165: IF FND_API.To_Boolean( p_commit ) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard call to get message count and if count is 1,
169: -- get message info.
170: FND_MSG_PUB.Count_And_Get
171: ( p_count => x_msg_count,
172: p_data => x_msg_data

Line 266: -- Standard Start of API savepoint

262: l_temp_uom_code VARCHAR2(3);
263:
264: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Explode_LPN_PUB;
268: -- Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
270: p_api_version ,

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

264: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
265: BEGIN
266: -- Standard Start of API savepoint
267: SAVEPOINT Explode_LPN_PUB;
268: -- Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
270: p_api_version ,
271: l_api_name ,
272: G_PKG_NAME )

Line 456: -- Standard check of p_commit.

452: END IF;
453:
454: -- End of API body
455:
456: -- Standard check of p_commit.
457: IF FND_API.To_Boolean( p_commit ) THEN
458: COMMIT WORK;
459: END IF;
460: -- Standard call to get message count and if count is 1,

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

456: -- Standard check of p_commit.
457: IF FND_API.To_Boolean( p_commit ) THEN
458: COMMIT WORK;
459: END IF;
460: -- Standard call to get message count and if count is 1,
461: -- get message info.
462: FND_MSG_PUB.Count_And_Get
463: ( p_count => x_msg_count,
464: p_data => x_msg_data

Line 521: -- Standard Start of API savepoint

517: l_result NUMBER;
518:
519: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
520: BEGIN
521: -- Standard Start of API savepoint
522: SAVEPOINT Transfer_LPN_Contents_PUB;
523: -- Standard call to check for call compatibility.
524: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
525: p_api_version ,

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

519: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
520: BEGIN
521: -- Standard Start of API savepoint
522: SAVEPOINT Transfer_LPN_Contents_PUB;
523: -- Standard call to check for call compatibility.
524: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
525: p_api_version ,
526: l_api_name ,
527: G_PKG_NAME )

Line 578: -- Standard check of p_commit.

574: WHERE lpn_id = p_lpn_id_source;
575:
576: -- End of API body
577:
578: -- Standard check of p_commit.
579: IF FND_API.To_Boolean( p_commit ) THEN
580: COMMIT WORK;
581: END IF;
582: -- Standard call to get message count and if count is 1,

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

578: -- Standard check of p_commit.
579: IF FND_API.To_Boolean( p_commit ) THEN
580: COMMIT WORK;
581: END IF;
582: -- Standard call to get message count and if count is 1,
583: -- get message info.
584: FND_MSG_PUB.Count_And_Get
585: ( p_count => x_msg_count,
586: p_data => x_msg_data

Line 677: -- Standard Start of API savepoint

673: AND organization_id = p_organization_id);
674:
675: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
676: BEGIN
677: -- Standard Start of API savepoint
678: SAVEPOINT Container_Required_Qty_PUB;
679: -- Standard call to check for call compatibility.
680: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
681: p_api_version ,

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

675: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
676: BEGIN
677: -- Standard Start of API savepoint
678: SAVEPOINT Container_Required_Qty_PUB;
679: -- Standard call to check for call compatibility.
680: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
681: p_api_version ,
682: l_api_name ,
683: G_PKG_NAME )

Line 945: -- Standard check of p_commit.

941: END IF;
942: END IF;
943: -- End of API body
944:
945: -- Standard check of p_commit.
946: IF FND_API.To_Boolean( p_commit ) THEN
947: COMMIT WORK;
948: END IF;
949: -- Standard call to get message count and if count is 1,

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

945: -- Standard check of p_commit.
946: IF FND_API.To_Boolean( p_commit ) THEN
947: COMMIT WORK;
948: END IF;
949: -- Standard call to get message count and if count is 1,
950: -- get message info.
951: FND_MSG_PUB.Count_And_Get
952: ( p_count => x_msg_count,
953: p_data => x_msg_data

Line 1033: -- Standard Start of API savepoint

1029: l_result NUMBER;
1030:
1031: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1032: BEGIN
1033: -- Standard Start of API savepoint
1034: SAVEPOINT Get_Outermost_LPN_PUB;
1035: -- Standard call to check for call compatibility.
1036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1037: p_api_version ,

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

1031: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1032: BEGIN
1033: -- Standard Start of API savepoint
1034: SAVEPOINT Get_Outermost_LPN_PUB;
1035: -- Standard call to check for call compatibility.
1036: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1037: p_api_version ,
1038: l_api_name ,
1039: G_PKG_NAME )

Line 1193: -- Standard check of p_commit.

1189:
1190: END IF;
1191: -- End of API body
1192:
1193: -- Standard check of p_commit.
1194: IF FND_API.To_Boolean( p_commit ) THEN
1195: COMMIT WORK;
1196: END IF;
1197: -- Standard call to get message count and if count is 1,

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

1193: -- Standard check of p_commit.
1194: IF FND_API.To_Boolean( p_commit ) THEN
1195: COMMIT WORK;
1196: END IF;
1197: -- Standard call to get message count and if count is 1,
1198: -- get message info.
1199: FND_MSG_PUB.Count_And_Get
1200: ( p_count => x_msg_count,
1201: p_data => x_msg_data

Line 1290: -- Standard Start of API savepoint

1286: WHERE parent_lpn_id = l_temp_lpn;
1287:
1288: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1289: BEGIN
1290: -- Standard Start of API savepoint
1291: SAVEPOINT Get_LPN_List_PUB;
1292: -- Standard call to check for call compatibility.
1293: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1294: p_api_version ,

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

1288: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1289: BEGIN
1290: -- Standard Start of API savepoint
1291: SAVEPOINT Get_LPN_List_PUB;
1292: -- Standard call to check for call compatibility.
1293: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1294: p_api_version ,
1295: l_api_name ,
1296: G_PKG_NAME )

Line 1447: -- Standard check of p_commit.

1443: END LOOP;
1444: END IF;
1445: -- End of API body
1446:
1447: -- Standard check of p_commit.
1448: IF FND_API.To_Boolean( p_commit ) THEN
1449: COMMIT WORK;
1450: END IF;
1451: -- Standard call to get message count and if count is 1,

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

1447: -- Standard check of p_commit.
1448: IF FND_API.To_Boolean( p_commit ) THEN
1449: COMMIT WORK;
1450: END IF;
1451: -- Standard call to get message count and if count is 1,
1452: -- get message info.
1453: FND_MSG_PUB.Count_And_Get
1454: ( p_count => x_msg_count,
1455: p_data => x_msg_data

Line 1804: -- Standard call to check for call compatibility

1800: mdebug ('Start Validate_Pick_Drop_Lpn.');
1801: END IF;
1802:
1803: --
1804: -- Standard call to check for call compatibility
1805: --
1806: IF NOT fnd_api.compatible_api_call(l_api_version_number
1807: , p_api_version_number
1808: , l_api_name