788: p_transaction_id, 3, 'ERROR', 'NO CHILD DELIVERY FOUND',
789: p_carrier_id);
790:
791: x_return_status := FND_API.G_RET_STS_ERROR ;
792: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRACKING_INFO');
793: FND_MSG_PUB.ADD;
794: FND_MSG_PUB.Count_And_Get
795: (
796: p_count => x_msg_count,
814: (l_sql_error_code||':'||l_sql_error_msg||' : '
815: ||' : '||l_procedure_name);
816: END IF;
817: x_return_status := FND_API.G_RET_STS_ERROR ;
818: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRACKING_INFO');
819: FND_MSG_PUB.ADD;
820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,