251: -- Lines, call 1) SO API 2) Update IB with IB trxns.
252: -- Pre-reqs :
253: -- Parameters :
254: --
255: -- Standard IN Parameters :
256: -- p_api_version IN NUMBER Default 1.0
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
256: -- p_api_version IN NUMBER Default 1.0
257: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
258: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
259: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
260: -- Standard OUT NOCOPY Parameters :
261: -- x_return_status OUT NOCOPY VARCHAR2 Required
262: -- x_msg_count OUT NOCOPY NUMBER Required
263: -- x_msg_data OUT NOCOPY VARCHAR2 Required
264: --
369: l_dummy NUMBER;
370: --
371: BEGIN
372:
373: -- Standard start of API savepoint
374: SAVEPOINT Process_Order_Pub;
375:
376: -- Initialize API return status to success
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: -- Initialize API return status to success
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: -- Standard call to check for call compatibility
380: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
381: G_PKG_NAME) THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
847: END IF;
848:
849: -- yazhou 07-Aug-2006 ends
850:
851: -- Standard check of p_commit
852: IF FND_API.To_Boolean(p_commit) THEN
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to commit work');
855: END IF;
855: END IF;
856: COMMIT WORK;
857: END IF;
858:
859: -- Standard call to get message count and if count is 1, get message
860: FND_MSG_PUB.Count_And_Get
861: ( p_count => x_msg_count,
862: p_data => x_msg_data,
863: p_encoded => fnd_api.g_false);
899: -- Function : For multiple Shipment Headers, book the orders
900: -- Pre-reqs :
901: -- Parameters :
902: --
903: -- Standard IN Parameters :
904: -- p_api_version IN NUMBER Default 1.0
905: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
906: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
907: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
904: -- p_api_version IN NUMBER Default 1.0
905: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
906: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
907: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
908: -- Standard OUT Parameters :
909: -- x_return_status OUT NOCOPY VARCHAR2 Required
910: -- x_msg_count OUT NOCOPY NUMBER Required
911: -- x_msg_data OUT NOCOPY VARCHAR2 Required
912: --
1053: FND_MSG_PUB.Initialize;
1054: -- jaramana End
1055: END IF;
1056:
1057: -- Standard check of p_commit
1058: IF FND_API.To_Boolean(p_commit) THEN
1059: COMMIT WORK;
1060: END IF;
1061:
1058: IF FND_API.To_Boolean(p_commit) THEN
1059: COMMIT WORK;
1060: END IF;
1061:
1062: -- Standard call to get message count and if count is 1, get message
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_count => x_msg_count,
1065: p_data => x_msg_data,
1066: p_encoded => fnd_api.g_false);
1103: -- Lines, Cancel if booked. Process either the header or the lines
1104: -- Pre-reqs :
1105: -- Parameters :
1106: --
1107: -- Standard IN Parameters :
1108: -- p_api_version IN NUMBER Default 1.0
1109: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1110: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1111: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1108: -- p_api_version IN NUMBER Default 1.0
1109: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
1110: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1111: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1112: -- Standard OUT Parameters :
1113: -- x_return_status OUT NOCOPY VARCHAR2 Required
1114: -- x_msg_count OUT NOCOPY NUMBER Required
1115: -- x_msg_data OUT NOCOPY VARCHAR2 Required
1116: --
1363:
1364: END LOOP;
1365: END IF;
1366:
1367: -- Standard check of p_commit
1368: IF FND_API.To_Boolean(p_commit) THEN
1369: COMMIT WORK;
1370: END IF;
1371:
1368: IF FND_API.To_Boolean(p_commit) THEN
1369: COMMIT WORK;
1370: END IF;
1371:
1372: -- Standard call to get message count and if count is 1, get message
1373: FND_MSG_PUB.Count_And_Get
1374: ( p_count => x_msg_count,
1375: p_data => x_msg_data,
1376: p_encoded => fnd_api.g_false);
4064: l_line_val_rec.shipment_priority := p_line_tbl(i).shipment_priority;
4065: l_line_val_rec.shipping_method := p_line_tbl(i).shipping_method;
4066:
4067: --Set values
4068: l_line_rec.item_type_code := 'STANDARD';
4069:
4070: --Fetch AHL_OSP_ORDER source document type id
4071: --AHL Document_type is defined to be 21
4072: l_line_rec.source_document_type_id := 21;
5451: -- Exchange to Service type or vice versa.
5452: -- Pre-reqs :
5453: -- Parameters :
5454: --
5455: -- Standard IN Parameters :
5456: -- p_api_version IN NUMBER Default 1.0
5457: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
5458: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
5459: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
5458: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
5459: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
5460: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
5461: -- p_module_type IN VARCHAR2 Default NULL.
5462: -- Standard OUT Parameters :
5463: -- x_return_status OUT NOCOPY VARCHAR2 Required
5464: -- x_msg_count OUT NOCOPY NUMBER Required
5465: -- x_msg_data OUT NOCOPY VARCHAR2 Required
5466: --
5520: l_temp_count NUMBER := 0;
5521:
5522: BEGIN
5523:
5524: -- Standard start of API savepoint
5525: SAVEPOINT Convert_SubTxn_Type_Pub;
5526:
5527: -- Initialize API return status to success
5528: x_return_status := FND_API.G_RET_STS_SUCCESS;
5526:
5527: -- Initialize API return status to success
5528: x_return_status := FND_API.G_RET_STS_SUCCESS;
5529:
5530: -- Standard call to check for call compatibility
5531: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
5532: G_PKG_NAME) THEN
5533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5534: END IF;
5647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Convert_Ship_Only_Lines returned with no exception');
5648: END IF;
5649: END IF;
5650:
5651: -- Standard check of p_commit
5652: IF FND_API.To_Boolean(p_commit) THEN
5653: COMMIT WORK;
5654: END IF;
5655:
5652: IF FND_API.To_Boolean(p_commit) THEN
5653: COMMIT WORK;
5654: END IF;
5655:
5656: -- Standard call to get message count and if count is 1, get message
5657: FND_MSG_PUB.Count_And_Get
5658: ( p_count => x_msg_count,
5659: p_data => x_msg_data,
5660: p_encoded => fnd_api.g_false);
6109: l_count NUMBER := 0;
6110:
6111: BEGIN
6112:
6113: -- Standard start of API savepoint
6114: SAVEPOINT Handle_Vendor_Change;
6115:
6116: -- Initialize API return status to success
6117: x_return_status := FND_API.G_RET_STS_SUCCESS;
6115:
6116: -- Initialize API return status to success
6117: x_return_status := FND_API.G_RET_STS_SUCCESS;
6118:
6119: -- Standard call to check for call compatibility
6120: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
6121: G_PKG_NAME) THEN
6122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6123: END IF;
6558: --
6559: -- Pre-reqs :
6560: -- Parameters :
6561: --
6562: -- Standard IN Parameters :
6563: -- p_api_version IN NUMBER Default 1.0
6564: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6565: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6566: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6564: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
6565: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
6566: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
6567: -- p_module_type IN VARCHAR2 Default NULL.
6568: -- Standard OUT Parameters :
6569: -- x_return_status OUT NOCOPY VARCHAR2 Required
6570: -- x_msg_count OUT NOCOPY NUMBER Required
6571: -- x_msg_data OUT NOCOPY VARCHAR2 Required
6572: --
6723: --Variables for Updating the CSI Instance End
6724:
6725: BEGIN
6726:
6727: -- Standard start of API savepoint
6728: SAVEPOINT Process_Osp_SerialNum_Change;
6729:
6730: -- Initialize API return status to success
6731: x_return_status := FND_API.G_RET_STS_SUCCESS;
6733: l_oe_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
6734: l_oe_lot_serial_tbl := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL;
6735:
6736:
6737: -- Standard call to check for call compatibility
6738: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
6739: G_PKG_NAME) THEN
6740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6741: END IF;