DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on STANDARD

Line 148: /* x_return_status OUT Standard API paramater */

144: /* description : Helper routine that Validates item for a given item ID */
145: /* in the mtl system items table */
146: /* Parameters Required: */
147: /* p_Inventory_Item_Id IN Item identifier */
148: /* x_return_status OUT Standard API paramater */
149: /* x_msg_count OUT Standard API paramater */
150: /* x_msg_data OUT Standard API paramater */
151: /*---------------------------------------------------------------------------*/
152: PROCEDURE Validate_InventoryItemID(p_Inventory_Item_ID IN NUMBER,

Line 149: /* x_msg_count OUT Standard API paramater */

145: /* in the mtl system items table */
146: /* Parameters Required: */
147: /* p_Inventory_Item_Id IN Item identifier */
148: /* x_return_status OUT Standard API paramater */
149: /* x_msg_count OUT Standard API paramater */
150: /* x_msg_data OUT Standard API paramater */
151: /*---------------------------------------------------------------------------*/
152: PROCEDURE Validate_InventoryItemID(p_Inventory_Item_ID IN NUMBER,
153: x_return_status OUT NOCOPY VARCHAR2,

Line 150: /* x_msg_data OUT Standard API paramater */

146: /* Parameters Required: */
147: /* p_Inventory_Item_Id IN Item identifier */
148: /* x_return_status OUT Standard API paramater */
149: /* x_msg_count OUT Standard API paramater */
150: /* x_msg_data OUT Standard API paramater */
151: /*---------------------------------------------------------------------------*/
152: PROCEDURE Validate_InventoryItemID(p_Inventory_Item_ID IN NUMBER,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,

Line 1170: /* x_return_status OUT Standard API paramater */

1166: /* X_Msg_Data will have a value if X_Msg_Count has value 1 */
1167: /* Parameters Required: */
1168: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1169: /* x_Product_Txn_Rec IN OUT database values are stored in this record*/
1170: /* x_return_status OUT Standard API paramater */
1171: /* x_msg_count OUT Standard API paramater */
1172: /* x_msg_data OUT Standard API paramater */
1173: /*---------------------------------------------------------------------------*/
1174: PROCEDURE Validate_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,

Line 1171: /* x_msg_count OUT Standard API paramater */

1167: /* Parameters Required: */
1168: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1169: /* x_Product_Txn_Rec IN OUT database values are stored in this record*/
1170: /* x_return_status OUT Standard API paramater */
1171: /* x_msg_count OUT Standard API paramater */
1172: /* x_msg_data OUT Standard API paramater */
1173: /*---------------------------------------------------------------------------*/
1174: PROCEDURE Validate_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1175: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,

Line 1172: /* x_msg_data OUT Standard API paramater */

1168: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1169: /* x_Product_Txn_Rec IN OUT database values are stored in this record*/
1170: /* x_return_status OUT Standard API paramater */
1171: /* x_msg_count OUT Standard API paramater */
1172: /* x_msg_data OUT Standard API paramater */
1173: /*---------------------------------------------------------------------------*/
1174: PROCEDURE Validate_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1175: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,
1176: x_return_status OUT NOCOPY VARCHAR2,

Line 1719: /* x_return_status OUT Standard API paramater */

1715: /* X_Msg_Data will have a value if X_Msg_Count has value 1 */
1716: /* Parameters Required: */
1717: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1718: /* p_Product_Txn_Rec IN database values are stored in this record */
1719: /* x_return_status OUT Standard API paramater */
1720: /* x_msg_count OUT Standard API paramater */
1721: /* x_msg_data OUT Standard API paramater */
1722: /*---------------------------------------------------------------------------*/
1723: PROCEDURE Compare_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,

Line 1720: /* x_msg_count OUT Standard API paramater */

1716: /* Parameters Required: */
1717: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1718: /* p_Product_Txn_Rec IN database values are stored in this record */
1719: /* x_return_status OUT Standard API paramater */
1720: /* x_msg_count OUT Standard API paramater */
1721: /* x_msg_data OUT Standard API paramater */
1722: /*---------------------------------------------------------------------------*/
1723: PROCEDURE Compare_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1724: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,

Line 1721: /* x_msg_data OUT Standard API paramater */

1717: /* p_Upd_ProdTxn_Rec IN user input values are stored in this record */
1718: /* p_Product_Txn_Rec IN database values are stored in this record */
1719: /* x_return_status OUT Standard API paramater */
1720: /* x_msg_count OUT Standard API paramater */
1721: /* x_msg_data OUT Standard API paramater */
1722: /*---------------------------------------------------------------------------*/
1723: PROCEDURE Compare_ProductTrxnRec(p_Upd_ProdTxn_Rec IN Csd_Logistics_Pub.Upd_ProdTxn_Rec_Type,
1724: p_Product_Txn_Rec IN Csd_Process_Pvt.Product_Txn_Rec,
1725: x_return_status OUT NOCOPY VARCHAR2,

Line 4007: Oe_Standard_Wf.SAVE_MESSAGES_OFF;

4003: mo_global.set_policy_context('S',l_org_id);
4004:
4005: --dbms_output.put_line('calling SAVE_MESSAGES_OFF');
4006:
4007: Oe_Standard_Wf.SAVE_MESSAGES_OFF;
4008:
4009: --dbms_output.put_line('Calling OE_Order_GRP.Process_Order');
4010: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;/*Fixed for bug#5968687*/
4011:

Line 4068: -- Standard check of p_commit.

4064: END IF;
4065: -- -------------------
4066: -- Api body ends here
4067: -- -------------------
4068: -- Standard check of p_commit.
4069: IF Fnd_Api.To_Boolean(p_commit)
4070: THEN
4071: COMMIT WORK;
4072: END IF;

Line 4081: -- Standard call to get message count and IF count is get message info.

4077: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4078: 'cancel_prodtxn completed');
4079: END IF;
4080:
4081: -- Standard call to get message count and IF count is get message info.
4082: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4083: p_data => x_msg_data);
4084: if(x_msg_count = 0) then
4085: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4180: -- Standard IN Parameters :

4176: -- Procedure name : SET_RSV_REC
4177: -- Type : Private
4178: -- Function : To initialize the record that is to be passed into INV api
4179: -- Pre-reqs :
4180: -- Standard IN Parameters :
4181: -- Standard OUT Parameters :
4182: -- SET_CREATE_REC Parameters:
4183: -- p_rsv_serial_number :
4184: -- x_rsv_rec :

Line 4181: -- Standard OUT Parameters :

4177: -- Type : Private
4178: -- Function : To initialize the record that is to be passed into INV api
4179: -- Pre-reqs :
4180: -- Standard IN Parameters :
4181: -- Standard OUT Parameters :
4182: -- SET_CREATE_REC Parameters:
4183: -- p_rsv_serial_number :
4184: -- x_rsv_rec :
4185: -- End of Comments.

Line 4197: -- Variables to check the log level according to the coding standards

4193:
4194: -- Declare local variables
4195: l_api_name CONSTANT VARCHAR2(30) := 'set_rsv_rec';
4196: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4197: -- Variables to check the log level according to the coding standards
4198: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4199:
4200: -- Declare cursors
4201:

Line 4298: -- Variables to check the log level according to the coding standards

4294: IS
4295: -- Declare local variables
4296: l_api_name CONSTANT VARCHAR2(30) := 'reserve_serial_number';
4297: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4298: -- Variables to check the log level according to the coding standards
4299: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4300: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4301: l_msg_Count NUMBER;
4302: l_msg_data VARCHAR2(4000);

Line 4550: -- Variables to check the log level according to the coding standards

4546: ) IS
4547: -- Declare local variables
4548: l_api_name CONSTANT VARCHAR2(30) := 'unreserve_serial_number';
4549: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4550: -- Variables to check the log level according to the coding standards
4551: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4552: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4553: l_msg_Count NUMBER;
4554: l_msg_data VARCHAR2(4000);