[Home] [Help]
84: | The type of transaction determines which statuses are valid for the
85: | transaction, and which status will be assigned to the unit after the
86: | transaction. The supported transactions can be divided into four basic
87: | groups, with a further division between issues and receipts in each
88: | group. The four groups are SO/RMA, Standard, Subinventory Transfer, and
89: | Intransit. The following diagram shows the relationships between
90: | the type of transaction, serial control, and status.
91: |
92: | A transaction may accept one or more statuses, but it only assigns one
104: | receipt 2 3 1 4 3
105: | receipt 5 1 4 Dyn 3
106: | receipt 6 1 4 Dyn 1
107: |
108: | Standard
109: | Issue/ Serial Available Assigned
110: | Receipt Control Status Status
111: | ------- --------- ------------ ------------
112: | receipt 1 6
247:
248: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
249: BEGIN
250: --
251: -- Standard start of API savepoint
252: SAVEPOINT InvQtyBetwn;
253: -- Standard Call to check for call compatibility
254: IF NOT FND_API.Compatible_API_Call(l_api_version
255: , p_api_version
249: BEGIN
250: --
251: -- Standard start of API savepoint
252: SAVEPOINT InvQtyBetwn;
253: -- Standard Call to check for call compatibility
254: IF NOT FND_API.Compatible_API_Call(l_api_version
255: , p_api_version
256: , l_api_name
257: , G_PKG_NAME) THEN
487: --
488: -- END of API Body
489: --
490:
491: -- Standard check of p_commit
492: IF FND_API.to_Boolean(p_commit) THEN
493: COMMIT;
494: END IF;
495:
492: IF FND_API.to_Boolean(p_commit) THEN
493: COMMIT;
494: END IF;
495:
496: -- Standard call to get message count and if count is 1, get message info
497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
498: , p_data => x_msg_data);
499:
500: EXCEPTION
636:
637: L_nothing VARCHAR2(10) ;
638: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
639: BEGIN
640: -- Standard start of API savepoint
641: SAVEPOINT SNUniqueCheck;
642: -- Standard Call to check for call compatibility
643: IF NOT FND_API.Compatible_API_Call(l_api_version
644: , p_api_version
638: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
639: BEGIN
640: -- Standard start of API savepoint
641: SAVEPOINT SNUniqueCheck;
642: -- Standard Call to check for call compatibility
643: IF NOT FND_API.Compatible_API_Call(l_api_version
644: , p_api_version
645: , l_api_name
646: , G_PKG_NAME) THEN
743: --
744: -- END of API body
745: --
746:
747: -- Standard check of p_commit
748: IF FND_API.to_Boolean(p_commit) THEN
749: COMMIT;
750: END IF;
751:
748: IF FND_API.to_Boolean(p_commit) THEN
749: COMMIT;
750: END IF;
751:
752: -- Standard call to get message count and if count is 1, get message info
753: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
754: , p_data => x_msg_data);
755:
756:
937: L_user_id NUMBER;
938: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
939: BEGIN
940: SAVEPOINT SNValidate;
941: -- Standard Call to check for call compatibility
942: IF NOT FND_API.Compatible_API_Call(l_api_version
943: , p_api_version
944: , l_api_name
945: , G_PKG_NAME) THEN
1149:
1150: IF FND_API.to_Boolean(p_commit) THEN
1151: COMMIT;
1152: END IF;
1153: -- Standard call to get message count and if count is 1, get message info
1154: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
1155: , p_data => x_msg_data);
1156:
1157: EXCEPTION