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 3993: Oe_Standard_Wf.SAVE_MESSAGES_OFF;

3989: mo_global.set_policy_context('S',l_org_id);
3990:
3991: --dbms_output.put_line('calling SAVE_MESSAGES_OFF');
3992:
3993: Oe_Standard_Wf.SAVE_MESSAGES_OFF;
3994:
3995: --dbms_output.put_line('Calling OE_Order_GRP.Process_Order');
3996: l_Line_Tbl_Type(1) := OE_Order_PUB.G_MISS_LINE_REC;/*Fixed for bug#5968687*/
3997:

Line 4054: -- Standard check of p_commit.

4050: END IF;
4051: -- -------------------
4052: -- Api body ends here
4053: -- -------------------
4054: -- Standard check of p_commit.
4055: IF Fnd_Api.To_Boolean(p_commit)
4056: THEN
4057: COMMIT WORK;
4058: END IF;

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

4063: 'csd.plsql.csd_logistics_util.cancel_prodtxn.end',
4064: 'cancel_prodtxn completed');
4065: END IF;
4066:
4067: -- Standard call to get message count and IF count is get message info.
4068: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4069: p_data => x_msg_data);
4070: if(x_msg_count = 0) then
4071: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 4166: -- Standard IN Parameters :

4162: -- Procedure name : SET_RSV_REC
4163: -- Type : Private
4164: -- Function : To initialize the record that is to be passed into INV api
4165: -- Pre-reqs :
4166: -- Standard IN Parameters :
4167: -- Standard OUT Parameters :
4168: -- SET_CREATE_REC Parameters:
4169: -- p_rsv_serial_number :
4170: -- x_rsv_rec :

Line 4167: -- Standard OUT Parameters :

4163: -- Type : Private
4164: -- Function : To initialize the record that is to be passed into INV api
4165: -- Pre-reqs :
4166: -- Standard IN Parameters :
4167: -- Standard OUT Parameters :
4168: -- SET_CREATE_REC Parameters:
4169: -- p_rsv_serial_number :
4170: -- x_rsv_rec :
4171: -- End of Comments.

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

4179:
4180: -- Declare local variables
4181: l_api_name CONSTANT VARCHAR2(30) := 'set_rsv_rec';
4182: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4183: -- Variables to check the log level according to the coding standards
4184: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4185:
4186: -- Declare cursors
4187:

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

4280: IS
4281: -- Declare local variables
4282: l_api_name CONSTANT VARCHAR2(30) := 'reserve_serial_number';
4283: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4284: -- Variables to check the log level according to the coding standards
4285: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4286: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4287: l_msg_Count NUMBER;
4288: l_msg_data VARCHAR2(4000);

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

4532: ) IS
4533: -- Declare local variables
4534: l_api_name CONSTANT VARCHAR2(30) := 'unreserve_serial_number';
4535: l_debug_module CONSTANT VARCHAR2(100) := 'csd.plsql.'||G_PKG_NAME||'.'||l_api_name;
4536: -- Variables to check the log level according to the coding standards
4537: l_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
4538: l_rsv_qry_Inp inv_reservation_global.mtl_reservation_rec_type;
4539: l_msg_Count NUMBER;
4540: l_msg_data VARCHAR2(4000);